>> 3) If I retrieve them without "at time zone" I will get them with >> the time zone that was stored in the first place, right ? > [...] > > This would be news to me. I don't think it's possible to *not* have a > timezone set on a session. The server will have a default timezone > based either on the local (server) system time or the setting of the > timezone variable in postgresql.conf. Additionally, libpq > applications will, I believe, issue a "set timezone" during initial > connection setup.
This is certainly the default behavior--I don't know whether there are settings to change it. All I know is that I regularly work with a database located in a different time zone, and displayed times are adjusted to my local time. -- Scott Ribe [EMAIL PROTECTED] http://www.killerbytes.com/ (303) 665-7007 voice ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
