Re: How to Convert Integer to Serial

From: John R Pierce <pierce(at)hogranch(dot)com>
To: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to Convert Integer to Serial
Date: 2010-10-29 05:09:45
Message-ID: 4CCA5719.4010409@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Shoaib Mir 2010-10-29 05:10:14 Re: [SQL] How to Convert Integer to Serial
Previous Message venkat 2010-10-29 05:02:10 Re: [SQL] How to Convert Integer to Serial

Browse pgsql-sql by date

  From Date Subject
Next Message Shoaib Mir 2010-10-29 05:10:14 Re: [SQL] How to Convert Integer to Serial
Previous Message venkat 2010-10-29 05:02:10 Re: [SQL] How to Convert Integer to Serial