Re: Inserting a new column in between.

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Inserting a new column in between.
Date: 2007-02-25 08:52:56
Message-ID: errip7$8g4$1@sea.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-novice

RPK wrote on 25.02.2007 09:44:
> Select * from tablename;
>
> the un-necessary field gets displayed in the last. However, you I can ignore
> that field altogether using filtered fields only in Select statement, but
> still sometimes it is necessary.
>
No it's not. SELECT * should be avoided by all means (except for ad-hoc queries).

Thomas

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Noel Faux 2007-02-25 09:00:50 Re: Inserting a new column in between.
Previous Message RPK 2007-02-25 08:44:31 Re: Inserting a new column in between.

Browse pgsql-novice by date

  From Date Subject
Next Message Noel Faux 2007-02-25 09:00:50 Re: Inserting a new column in between.
Previous Message RPK 2007-02-25 08:44:31 Re: Inserting a new column in between.