Skip site navigation (1) Skip section navigation (2)

Re: select issue with order v8.1

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Terry <td3201(at)gmail(dot)com>
Cc: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: select issue with order v8.1
Date: 2010-02-26 22:46:00
Message-ID: 6779.1267224360@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-general
Terry <td3201(at)gmail(dot)com> 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

In response to

Responses

pgsql-general by date

Next:From: Scott MarloweDate: 2010-02-26 22:52:39
Subject: Re: select issue with order v8.1
Previous:From: TerryDate: 2010-02-26 21:52:45
Subject: Re: select issue with order v8.1

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group