Re: [BUGS] BUG #2304: Time zone bug: '05:04 GMT+3' processing as '05:04:00 -03'

2006-03-08 Thread Tom Lane
"Alexander Pivovarov" <[EMAIL PROTECTED]> writes: > # select '05:04 GMT+3'::time with time zone; >timetz > - > 05:04:00-03 > (1 row) This isn't a bug; it's expected. The "GMT+n" syntax is defined by a different standard than the one we follow for timestamp output, and the two sta

[BUGS] BUG #2304: Time zone bug: '05:04 GMT+3' processing as '05:04:00 -03'

2006-03-08 Thread Alexander Pivovarov
The following bug has been logged online: Bug reference: 2304 Logged by: Alexander Pivovarov Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.3 Operating system: FreeBSD 6.1 Description:Time zone bug: '05:04 GMT+3' processing as '05:04:00 -03' Details: #