Re: parse error in timestamp function - Mailing list pgsql-general

From Marek
Subject Re: parse error in timestamp function
Date
Msg-id a4r4a5$dj$1@news.tpi.pl
Whole thread Raw
In response to parse error in timestamp function  (Bart Teeuwisse <bart-postgres@7-sisters.com>)
Responses Re: parse error in timestamp function  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-general
no its not a bug.
following HISTORY file:
"The timestamp() function is no longer available. Use timestamp 'string'
instead, or CAST"
for exapmle
select timestamp '2002-02-14'
timestamptz
--------------------
2002-02-14 00:00:00+01



marek

Uzytkownik "Bart Teeuwisse" <bart-postgres@7-sisters.com> napisal w
wiadomosci news:3C705FD0.7080508@7-sisters.com...
> The following examples from 4.8. Date/Time Functions and Operators fail
> with parse errors in PG 7.2:
>
> select timestamp(date '2000-12-25');
> ERROR: parser: parse error at or near "date"
>
> select timestamp(date '1998-02-24',time '23:07');
> ERROR: parser: parse error at or near "date"
>
> The same examples do work in PG 7.1.3.
>
> Is this a bug?
>



pgsql-general by date:

Previous
From: Oliver Elphick
Date:
Subject: Re: Using variables from c to be passed into PQexec
Next
From: wsheldah@lexmark.com
Date:
Subject: Re: MDB 2 POSTGRESQL MIGRATION PROBLEM