Re: RETURNING clause: how to specifiy column indexes? - Mailing list pgsql-general

From Tom Lane
Subject Re: RETURNING clause: how to specifiy column indexes?
Date
Msg-id 12796.1197439644@sss.pgh.pa.us
Whole thread Raw
In response to RETURNING clause: how to specifiy column indexes?  (Ken Johanson <pg-user@kensystem.com>)
Responses Re: RETURNING clause: how to specifiy column indexes?
List pgsql-general
Ken Johanson <pg-user@kensystem.com> writes:
> While the values of an API that specifies the table's columns by
> ordinaility may seem dubious, it is an API that I think should be
> implemented anyway.

Every few weeks we get a complaint from someone who thinks that it
should be easy to rearrange the logical order of table columns.
If that comes to pass, it would be a seriously bad idea to have
encouraged applications to rely on table column numbers.  And given
the number of votes for that (probably in the hundreds by now)
versus the number of votes for this idea (one), I think column
reordering is much more likely to get done ...

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Terminology definitions/meaning
Next
From: "Trevor Talbot"
Date:
Subject: Re: Hijack!