Re: select issue with order v8.1
От
Tom Lane
Тема
Re: select issue with order v8.1
Дата
Msg-id
6779.1267224360@sss.pgh.pa.us
Ответ на
Re: select issue with order v8.1 (Terry)
Список
Дерево обсуждения
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 по дате отправления