Path: csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!aioe.org!feeder.news-service.com!weretis.net!feeder4.news.weretis.net!newsfeed.utanet.at!newscore.univie.ac.at!aconews-feed.univie.ac.at!aconews.univie.ac.at!not-for-mail From: "Laurenz Albe" Newsgroups: comp.databases.postgresql References: <77db128d-ae4c-4ab9-ad2d-62b2e885d48b@r27g2000prr.googlegroups.com> Subject: Re: Timestamp with Timezone (Oracle versus Postgres) Date: Tue, 14 Jun 2011 11:43:46 +0200 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.5931 X-RFC2646: Format=Flowed; Original X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.6090 Organization: dienste.wien.at ISP Message-ID: <1308044648.428579@proxy.dienste.wien.at> X-Cache: nntpcache 2.3.3 (see http://www.nntpcache.org/) Lines: 33 NNTP-Posting-Host: 141.203.254.23 X-Trace: 1308044650 aconews.univie.ac.at 10580 141.203.254.23 X-Complaints-To: abuse@univie.ac.at Xref: x330-a1.tempe.blueboxinc.net comp.databases.postgresql:132 Jasen Betts wrote:> On 2011-06-10, vinu wrote: >> Is timestamp with timezone a ANSI SQL (or some other) standard data >> type ? > yes, there are rules about how it behaves and as I understand it > postgres mets all the requirements. Maybe PostgreSQL meets all the requirements, but as I researched here http://archives.postgresql.org/pgsql-general/2009-06/msg01372.php the Standard seems to suggest that the time zone information should be stored along with the date. Tom Lane did not seem to disagree: http://archives.postgresql.org/pgsql-general/2009-06/msg01389.php I didn't find anything in the Standard that is explicit on how time zone information should be handled, but it seems that what the writers had in mind was closer to Oracle's implementation than to PostgreSQL's. [...] >> In this an issue with postgresql or a conscious implementation >> decision? > as far as I can tell is was a conscious decision. Even if, Tom Lane's remark quoted above indicates that there have been debates (I'm too lazy to research), and the status quo is retained at least partly because other options would be inconvenient to implement. Yours, Laurenz Albe