Re: Add Column BEFORE/AFTER another column
| От | Matthew |
|---|---|
| Тема | Re: Add Column BEFORE/AFTER another column |
| Дата | |
| Msg-id | 46CF4B1A.8020000@voilaip.com обсуждение исходный текст |
| Ответ на | Re: Add Column BEFORE/AFTER another column (Bill Moran <wmoran@potentialtech.com>) |
| Ответы |
Re: Add Column BEFORE/AFTER another column
Re: Add Column BEFORE/AFTER another column Re: Add Column BEFORE/AFTER another column |
| Список | pgsql-general |
Hey Bill,
> It does not.
Bummer.
> To get your columns in a specific order, specify the column names in
> that order in your SELECT statement. The SQL standard doesn't provide
> for any other way to guarantee column order, and neither does Postgres.
Yes, I realize this and we do identify our columns during select
statements, but when you look at a table using a tool like phpPGAdmin or
pgAdmin3, the columns are displayed in some defined order. It's much
easier to see your data/columns in some logical order (ie: all the cost
columns next to each other).
Thanks,
Matthew
В списке pgsql-general по дате отправления: