Re: timestamptz alias

From: Jim Nasby <jimn(at)enterprisedb(dot)com>
To: Markus Schaber <schabi(at)logix-tt(dot)com>
Cc: PostgreSQL-development hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: timestamptz alias
Date: 2006-10-06 02:18:40
Message-ID: 06013250-FEB2-431C-9EE9-DB4CB037FE9E@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs pgsql-hackers

On Oct 4, 2006, at 10:52 AM, Markus Schaber wrote:
> Andrew Dunstan wrote:
>>> It's not only about documenting the pure existence of the aliases
>>> (which
>>> was already documented in the table on the datatype TOC page),
>>> it's also
>>> about telling the user which of the names are the ones to avoid,
>>> and the
>>> reasons to do so.
>>
>> *blink* Why do any need to be avoided? What you use is a matter of
>> taste, and your organisation's coding standards. From a purely
>> technical
>> POV I don't see any reason to avoid using either the canonical type
>> names or the various aliases.
>
> At least compatibility with the SQL standard, as well as with other
> Databases might be a reason.

It would be nice to denote types/aliases that are and aren't ANSI. A
number are marked in the docs, but it would be good to add the info
to that summary table.
--
Jim Nasby jim(at)nasby(dot)net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)

--
Jim Nasby jimn(at)enterprisedb(dot)com
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Andrew Dunstan 2006-10-06 07:35:55 Re: timestamptz alias
Previous Message Bruce Momjian 2006-10-05 02:04:41 Re: Texinfo docs/target

Browse pgsql-hackers by date

  From Date Subject
Next Message Jim Nasby 2006-10-06 02:40:57 Re: [HACKERS] timestamp subtraction (was Re: formatting intervals with to_char)
Previous Message Tom Lane 2006-10-06 01:36:34 Re: [HACKERS] timestamp subtraction (was Re: formatting intervals with to_char)