Postgres Pro
Downloads
Home   >   mailing lists

Re: How to Convert Integer to Serial - Mailing list pgsql-general

From John R Pierce
Subject Re: How to Convert Integer to Serial
Date
Msg-id 4CCA5719.4010409@hogranch.com
Whole thread Raw
In response to How to Convert Integer to Serial  (venkat <ven.tammineni@gmail.com>)
List pgsql-general
Tree view 
On 10/28/10 9:48 PM, venkat wrote:
> Dear All,
>
>   I want to convert integer datatype to serial datatype.. is that
> possible.Please let me know.
>

SERIAL is not actually a data type, its simply an integer with an
associated sequence.    what Shoab Mir gave will add this sequence to
the existing integer

pgsql-general by date:

Previous
From: venkat
Date:
Subject: Re: [SQL] How to Convert Integer to Serial
Next
From: Shoaib Mir
Date:
Subject: Re: [SQL] How to Convert Integer to Serial