Re: select issue with order v8.1

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: select issue with order v8.1
Дата
Msg-id
6779.1267224360@sss.pgh.pa.us
Ответ на
Список
Дерево обсуждения
select issue with order v8.1 Terry <td3201@gmail.com>
Re: select issue with order v8.1 Tom Lane <tgl@sss.pgh.pa.us>
Re: select issue with order v8.1 Scott Marlowe <scott.marlowe@gmail.com>
Re: select issue with order v8.1 Terry <td3201@gmail.com>
Re: select issue with order v8.1 Terry <td3201@gmail.com>
Re: select issue with order v8.1 Scott Marlowe <scott.marlowe@gmail.com>
Re: select issue with order v8.1 Terry <td3201@gmail.com>
Re: select issue with order v8.1 Tom Lane <tgl@sss.pgh.pa.us>
Re: select issue with order v8.1 Scott Marlowe <scott.marlowe@gmail.com>
Re: select issue with order v8.1 Terry <td3201@gmail.com>
Re: select issue with order v8.1 Adrian Klaver <adrian.klaver@gmail.com>
Terry  writes:
> I am somewhat confused.  My app is detecting it as a serial data type
> but describing the table shows that its an integer.  What am I
> missing?

> dssystem=# \d clients_event_log
>                                        Table "public.clients_event_log"
>      Column     |          Type           |
>  Modifiers
> ----------------+-------------------------+-------------------------------------------------------------------
>  ev_id          | integer                 | not null default
> nextval('clients_event_log_ev_id_seq'::regclass)

Nothing.  "Serial" is nothing but a shorthand for an integer column
with a default like that.

			regards, tom lane
В списке pgsql-general по дате отправления
От: Terry
Дата:
От: Scott Marlowe
Дата:
FAQ