Re: [DOCS] Is timestamptz alias documented?

2010-12-07 Thread Alvaro Herrera
Excerpts from Tom Lane's message of mar dic 07 15:35:53 -0300 2010: > Chris 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

Re: [DOCS] Is timestamptz alias documented?

2010-12-07 Thread Chris
On Tue, Dec 7, 2010 at 11:35 AM, Tom Lane wrote: > See table 8-1 here: > http://www.postgresql.org/docs/9.0/static/datatype.html > > We don't emphasize it, since it's a nonstandard Postgres-ism. Thanks. I guess I understand why you don't want to emphasize a non-standard Postgres feature. But why

Re: [DOCS] Is timestamptz alias documented?

2010-12-07 Thread Tom Lane
Chris writes: > I have been unable to find where it is mentioned that timestamptz can be > used as shorthand for 'timestamp with time zone'. See table 8-1 here: http://www.postgresql.org/docs/9.0/static/datatype.html We don't emphasize it, since it's a nonstandard Postgres-ism. > Is this a new

[DOCS] Is timestamptz alias documented?

2010-12-07 Thread Chris
I have been unable to find where it is mentioned that timestamptz can be used as shorthand for 'timestamp with time zone'. I discovered I could use it by trying it out after I saw someone else use it. Is this a new alias, or has it been around for some time? I am using 9.0, and have not tried it on