From: | John Burski <John(dot)Burski(at)911ep(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: date_part function |
Date: | 2000-12-29 21:56:58 |
Message-ID: | 3A4D08AA.A2DEAA1F@911ep.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
My bad!!
I was reading the docs for 7.0.3 (which I've installed on my workstation)
and ssh'd across to a different box using an older version (6.5.2). Too
many xterms running at the same time. Sheesh! I need a vacation!
Tom Lane wrote:
> John Burski <John(dot)Burski(at)911ep(dot)com> writes:
> > 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
>
> Odd. It works fine for me. What do you get from psql's "\df date_part"?
>
> regards, tom lane
--
John Burski
Chief IT Cook and Bottlewasher
911 Emergency Products, St. Cloud, MN
(320) 656 0076 www.911ep.com
++++++++++++++++++++++++++++++++++
+ How's your cheese holding out? +
++++++++++++++++++++++++++++++++++
From | Date | Subject | |
---|---|---|---|
Next Message | Charles Curley | 2000-12-30 00:13:14 | Re: date_part function |
Previous Message | Tom Lane | 2000-12-29 20:53:38 | Re: date_part function |