Re: alter table add column - specify where the column will go?

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: alter table add column - specify where the column will go?
Date: 2010-11-24 09:43:16
Message-ID: icimnk$eq0$1@dough.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Grzegorz Jaśkiewicz, 24.11.2010 10:37:
> just never use SELECT *, but always call columns by names. You'll
> avoid having to depend on the order of columns, which is never
> guaranteed, even if the table on disk is one order, the return columns
> could be in some other.
>
I always try to convince people of this as well, but when they ask me under which circumstances this could happen, I can't think of a proper example.

Does anybody have an example that would show this?

Regards
Thomas

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message pasman pasmański 2010-11-24 09:59:10 Optimizing query
Previous Message Grzegorz Jaśkiewicz 2010-11-24 09:37:02 Re: alter table add column - specify where the column will go?