| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | Tomas Lehuta <lharp(at)aurius(dot)sk> |
| Cc: | <pgsql-hackers(at)postgresql(dot)org>, <pgsql-general(at)postgresql(dot)org>, <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: timestamp parse error |
| Date: | 2002-09-20 14:38:25 |
| Message-ID: | 20020920073512.E40130-100000@megazone23.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers pgsql-sql |
On Fri, 20 Sep 2002, Tomas Lehuta wrote:
> Hello!
>
> i'm using PostgreSQL 7.2.1 and got strange parse errors..
> could somebody tell me what's wrong with this timestamp query example?
>
> PostgreSQL said: ERROR: parser: parse error at or near "date"
> Your query:
>
> select timestamp(date '1998-02-24', time '23:07')
>
> example is from PostgreSQL help and certainly worked in previous versions of
> pgsql.. but in 7.2.1 it does not. had anything changed and not been updated
> in pgsql manuals or is it a bug?
Presumably it's a manual example that didn't get changed. Timestamp(...)
is now a specifier for the type with a given precision. You can use
"timestamp"(date '1998-02-24', time '23:07') or datetime math (probably
something like date '1998-02-24' + time '23:07' and possibly a cast)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-09-20 14:43:48 | Re: BYTEA |
| Previous Message | Tom Lane | 2002-09-20 14:37:22 | Re: missed features and unhappy changes when pg 7.1->7.2 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mike Mascari | 2002-09-20 14:57:00 | Re: Win32 rename()/unlink() questions |
| Previous Message | Bruce Momjian | 2002-09-20 14:31:22 | Re: Win32 rename()/unlink() questions |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ricardo Javier Aranibar León | 2002-09-20 14:46:26 | query concat |
| Previous Message | Aaron Held | 2002-09-20 14:09:06 | Re: Performance w/ multiple WHERE clauses |