Horton

Re: full featured alter table?

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Mike Mascari <mascarm@mascari.com>
Cc: Ernest E Vogelsinger <ernest@vogelsinger.at>, "Nigel J. Andrews" <nandrews@investsystems.co.uk>, Sven Köhler <skoehler@upb.de>, pgsql-general@postgresql.org
Date: 2003-06-15T17:25:19Z
Lists: pgsql-general 
Mike Mascari <mascarm@mascari.com> writes:
> The proposal does beg the question:
> Why would a default tuple-attribute order be stored in the database
> but not relation-tuple order?

A good argument in terms of pure relational-calculus theory ... but
we're dealing with SQL here, not relational calculus.  The SQL spec
explicitly states that column ordering is significant while row ordering
is not.

			regards, tom lane