Skip site navigation (1) Skip section navigation (2)

Re: Domain Support -- another round

From: Thomas Lockhart <thomas(at)fourpalms(dot)org>
To: Fernando Nasser <fnasser(at)redhat(dot)com>
Cc: Rod Taylor <rbt(at)zort(dot)ca>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>,Peter Eisentraut <peter_e(at)gmx(dot)net>, pgsql-patches(at)postgresql(dot)org,Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Subject: Re: Domain Support -- another round
Date: 2002-03-21 16:10:08
Message-ID: 3C9A05E0.B39B1A20@fourpalms.org (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
> SQL'99 explicitly forbids it.  Please refer to my posting to HACKERS
> for the SQL document reference.

The fact that a standard "forbids" something does not necessarily mean
it is a bad idea, as I'm sure you know. Is there any reason that the
standard forbids using domains inside arrays, other than someone on the
standards committee realized that it would be hard for their company to
implement it? That is, does allowing domains in arrays lead to
inconsistancies or fundamental issues with relational algebra or other
set logic that should keep it out of the next set of standards?

If Postgres was developed to only the current standard, it would never
have been written. And since the start of the open source days, if we
had worked solely to get it to conform to the current standard we'd be
starting at ground zero for implementing SQL99, since many of our
features now appear in that standard. Someone cheated and looked at what
we could already do... ;)

                     - Thomas

In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2002-03-21 16:19:14
Subject: Re: Function call crashes server
Previous:From: Rod TaylorDate: 2002-03-21 15:42:18
Subject: Re: [PATCHES] Domain Support -- another round

pgsql-patches by date

Next:From: Fernando NasserDate: 2002-03-21 16:22:57
Subject: Re: Domain Support -- another round
Previous:From: Ferdinand SmitDate: 2002-03-21 15:53:30
Subject: Re: pg_dump and transactions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group