| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | F Harvell <fharvell(at)fts(dot)net> |
| Cc: | Barry Lind <barry(at)xythos(dot)com>, pgsql-general(at)postgresql(dot)org, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: [HACKERS] bug or change in functionality in 7.2? |
| Date: | 2001-11-19 16:24:08 |
| Message-ID: | 15434.1006187048@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
F Harvell <fharvell(at)fts(dot)net> writes:
> In my experiences with other databases, the notations indicated in
> the Date/Darwin book do indeed work whereas the PostgreSQL notation
> (with the closing single quote following the start to end
> specification) do not work.
In current sources:
regression=# select INTERVAL '2:12:35' HOUR TO SECOND;
interval
----------
02:12:35
(1 row)
regression=# select INTERVAL '2:12:35 HOUR TO SECOND';
ERROR: Bad interval external representation '2:12:35 HOUR TO SECOND'
regression=#
Looks like Lockhart agrees with you ;-)
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alexis Maldonado | 2001-11-19 16:31:46 | Re: Packages for RH7.2 |
| Previous Message | Henk van Lingen | 2001-11-19 16:17:31 | Re: revoke all from public ? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | mlw | 2001-11-19 16:43:55 | Re: postgresql.conf |
| Previous Message | F Harvell | 2001-11-19 16:16:49 | Re: [HACKERS] bug or change in functionality in 7.2? |