Re: [SQL] "TZ"/"tz" not supported

2008-06-20 Thread Peter Kovacs
reason for this limitation or is it just the implementation waiting to be completed (nobody has had an itch intensive enough to scratch it)? Thanks Peter On Fri, Jun 20, 2008 at 8:50 AM, A. Kretschmer <[EMAIL PROTECTED]> wrote: > am Fri, dem 20.06.2008, um 8:35:10 +0200 mailte Peter K

Re: [SQL] "TZ"/"tz" not supported

2008-06-19 Thread Peter Kovacs
Thank you, Andreas! Your advice is very useful to me. I would still be interested why "TZ" is not accepted in the format string. Thanks Peter On Fri, Jun 20, 2008 at 8:15 AM, A. Kretschmer <[EMAIL PROTECTED]> wrote: > am Fri, dem 20.06.2008, um 7:51:50 +0200 mailte Pet

[SQL] "TZ"/"tz" not supported

2008-06-19 Thread Peter Kovacs
Hi, Execution of the following statement aborts with the error message in the Subject: select to_timestamp('2008-06-20 02:30:00 GMT', '-MM-DD HH24:MI:SS TZ'); Does this message mean that this particular PostgreSQL installation doesn't support timezones? -- select * from pg_catal

[SQL] Cheers for DISTINCT ON

2008-01-07 Thread Peter Kovacs
I just wanted to give my cheers for DISTINCT ON. It is a great feature, I've just found a really good use for it. I am just wondering why it didn't make it into the standards. On a slightly unrelated note, I had the opportunity to work with EQUEL for a short period of time some 15 years ago before