On Tue, Dec 7, 2010 at 2:20 PM, Alvaro Herrera <[email protected]> wrote: > Excerpts from Tom Lane's message of mar dic 07 15:35:53 -0300 2010: >> Chris <[email protected]> writes: > >> > Is this a new alias, or >> > has it been around for some time? >> >> It's been around since the '90s I'm sure, maybe even back to Berkeley days. > > It appeared later; "timestamp" was the alias for "timestamp with time > zone" previously. But this was against the SQL standard so the new > alias was introduced as a backwards incompatible change. There are no > hits for a "grep -r timestamptz src/backend" in 7.1, but they are there > in 7.2. 2002 or so, then.
I think it'd be helpful to make brief mention of this in the section on "Date/Time Types", perhaps along the lines of the attached patch. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
timestamptz-doc.patch
Description: Binary data
-- Sent via pgsql-docs mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs
