Re: enumerating rows
| От | Kovacs Zoltan |
|---|---|
| Тема | Re: enumerating rows |
| Дата | |
| Msg-id | Pine.LNX.4.21.0104111630350.3812-100000@pc10.radnoti-szeged.sulinet.hu обсуждение исходный текст |
| Ответ на | Re: enumerating rows ("Poul L. Christiansen" <poulc@cs.auc.dk>) |
| Ответы |
Re: enumerating rows
|
| Список | pgsql-sql |
> Use the "serial" column type. Unfortunately it's not what I expect. Assume that I have an arbitrary "SELECT expr1 as column1, expr2 as column2, ..." which gives column1 | column2 | ... --------+---------+- ... ......data.............. ........................ I would like to get the same result with the only plus column row_no: row_no | column1 | column2 | ... -------+---------+---------+- ... 1 | ......data.............. 2 | ........................ ................................. with a new SELECT statement: "SELECT ?????, expr1 as column1, expr2 as column2, ...". What to write instead of ?????? TIA, Zoltan
В списке pgsql-sql по дате отправления: