date_part??? - Mailing list pgsql-general

From jerome
Subject date_part???
Date
Msg-id 200208290911.g7T9BJU45264@gmanewmedia.com
Whole thread Raw
Responses Re: date_part???  (Martijn van Oosterhout <kleptog@svana.org>)
Re: date_part???  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-general
i have a table
 Attribute |   Type    | Modifier
-----------+-----------+----------
 test      | timestamp |

SELECT date_part('hour', TIMESTAMP 'timestamp(test)') from testing;
ERROR:  Bad timestamp external representation 'timestamp(test)'

** this one gives me an error but the DOCU says:
  --  date_part(text, timestamp)

pgsql-general by date:

Previous
From: "Nikhil G. Daddikar"
Date:
Subject: Deleting foreign key constraints
Next
From: Mark Kirkwood
Date:
Subject: Re: Free space mapping (was Re: Multi-Versions and Vacuum)