Обсуждение: date_part function
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? +
++++++++++++++++++++++++++++++++++
try this
duccini=> select date_part('dow', 'now'::date);
date_part
---------
5
(1 row)
-duck
On Fri, 29 Dec 2000, John Burski wrote:
> 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? +
> ++++++++++++++++++++++++++++++++++
>
>
>
-----------------------------------------------------------------------------
david@backpack.com BackPack Software, Inc. www.backpack.com
+1 651.645.7550 voice "Life is an Adventure.
+1 651.645.9798 fax Don't forget your BackPack!"
-----------------------------------------------------------------------------
Just the ticket!
Thanks!
"D. Duccini" wrote:
> try this
>
> duccini=> select date_part('dow', 'now'::date);
> date_part
> ---------
> 5
> (1 row)
>
> -duck
>
> On Fri, 29 Dec 2000, John Burski wrote:
>
> > 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? +
> > ++++++++++++++++++++++++++++++++++
> >
> >
> >
>
> -----------------------------------------------------------------------------
> david@backpack.com BackPack Software, Inc. www.backpack.com
> +1 651.645.7550 voice "Life is an Adventure.
> +1 651.645.9798 fax Don't forget your BackPack!"
> -----------------------------------------------------------------------------
--
John Burski
Chief IT Cook and Bottlewasher
911 Emergency Products, St. Cloud, MN
(320) 656 0076
++++++++++++++++++++++++++++++++++
+ How's your cheese holding out? +
++++++++++++++++++++++++++++++++++
John Burski <John.Burski@911ep.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
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.Burski@911ep.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? +
++++++++++++++++++++++++++++++++++
On Fri, Dec 29, 2000 at 03:56:58PM -0600, John Burski wrote:
> 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!
You may need a vacation, but you also need to set your shell prompt up to
set the xterm's title bar to indicate the host and working directory. For
bash:
# Show path in xterm title bar. Originally from Russel & Crawford, "Unix &
# Linux Answers", Osborne, 1998
if [ "$TERM" = xterm ]; then
PS1='\u@\h \$ \[\033]0;xterm \h:\w\007\]'
else
PS1='\u@\h \w \\$ '
fi
--
-- C^2
No windows were crashed in the making of this email.
Looking for fine software and/or web pages?
http://w3.trib.com/~ccurley