hernan gonzalez wrote: > > hernan> The support of timezones is really crippled > > ?hernan> now. > > > > Crippled how? > > Well, among other things, no builtin date-timetype allows me to save > the timezone (or even the offset). > No type allows to treat this three datetimes as different values. > '2010-07-27 10:30 GMT+4' '2010-07-27 09:30 GMT+5' '2010-07-27 10:30 GMT+0' > The ANSI spec at least permits that.
I think there is general agreement that we should have a timezone data type which validates against pg_timezone_names().name. It might be enough to just document how users can create such a domain data type, but I don't know of a way to do that. Is this a TODO? -- Bruce Momjian <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers