Re: RETURNING clause: how to specifiy column indexes?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ken Johanson <pg-user(at)kensystem(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: RETURNING clause: how to specifiy column indexes?
Date: 2007-12-12 06:07:24
Message-ID: 12796.1197439644@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-jdbc

Ken Johanson <pg-user(at)kensystem(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Trevor Talbot 2007-12-12 06:38:17 Re: Hijack!
Previous Message Tom Lane 2007-12-12 05:56:50 Re: Terminology definitions/meaning

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2007-12-12 06:45:09 Re: RETURNING clause: how to specifiy column indexes?
Previous Message Ken Johanson 2007-12-12 05:53:42 RETURNING clause: how to specifiy column indexes?