date_part function - Mailing list pgsql-novice

From John Burski
Subject date_part function
Date
Msg-id 3A4CAF67.6ACFCF98@911ep.com
Whole thread Raw
Responses Re: date_part function  ("D. Duccini" <duccini@backpack.com>)
Re: date_part function  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
I was putzing around with the date/time functions to get a feel for how
they work, when I ran across this bit of puzzling behavior.  I'm running
PostgreSQL 7.0.3 on a Red Hat 6.1 box.

I submitted the following query:

     select date_part('dow', timestamp 'now');

and received the following results:

     ERROR:  Function 'date_part(text, timestamp)' does not exist
      Unable to identify a function which satisfies the given
     argument types
      You will have to retype your query using explicit typecasts

However, the user documentation seems to indicate that this function is
an integral part of PostgreSQL.

What gives?

Regards,

--
John Burski
Chief IT Cook and Bottlewasher
911 Emergency Products, St. Cloud, MN
(320) 656 0076

++++++++++++++++++++++++++++++++++
+ How's your cheese holding out? +
++++++++++++++++++++++++++++++++++




pgsql-novice by date:

Previous
From: Karla Peralta
Date:
Subject: Re: Transactions
Next
From: "D. Duccini"
Date:
Subject: Re: date_part function