Re: alter table add column - specify where the column will go? - Mailing list pgsql-general

From Thomas Kellerer
Subject Re: alter table add column - specify where the column will go?
Date
Msg-id icimnk$eq0$1@dough.gmane.org
Whole thread Raw
In response to Re: alter table add column - specify where the column will go?  (Grzegorz Jaśkiewicz <gryzman@gmail.com>)
Responses Re: alter table add column - specify where the column will go?
Re: alter table add column - specify where the column will go?
List 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'tthink of a proper example. 

Does anybody have an example that would show this?

Regards
Thomas


pgsql-general by date:

Previous
From: Grzegorz Jaśkiewicz
Date:
Subject: Re: alter table add column - specify where the column will go?
Next
From: pasman pasmański
Date:
Subject: Optimizing query