[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-sql
Subject:    Re: [SQL] Timestamp output
From:       Tom Lane <tgl () sss ! pgh ! pa ! us>
Date:       2002-02-27 5:48:04
[Download RAW message or body]

"Christopher Kings-Lynne" <chriskl@familyhealth.com.au> writes:
> Hmmm...it seems to me that an easier way is to edit the pg_dump from the
> previous version to add (0) in everywhere.

Well, sure, if you haven't loaded your dump yet.

Note, however, that this does *not* provide a closer approximation to
the behavior of older versions than 7.2 does by default.  Older versions
do support fractional-second timestamps, though only to a couple of
digits IIRC.

The main thing that would be useful to avoid breaking client code that
can't handle fractional-second timestamps is to replace calls to
now() and current_timestamp with current_timestamp(0).

			regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
[prev in list] [next in list] [prev in thread] [next in thread]