Of course, a bigger question is why the ::text cast is needed at all.
---------------------------------------------------------------------------
Dennis Gearon wrote:
> Because that's the name of the sequence, not the value coming out of the sequence.
>
> 3/4/2003 10:54:34 PM, John Smith <john_smith_45678@yahoo.com> wrote:
>
> >
> >
> > Date: Tue, 4 Mar 2003 22:54:34 -0800 (PST)
> >
> > From: John Smith <john_smith_45678@yahoo.com>
> > Subject:[GENERAL] nextval::text
> > To: pgsql-general@postgresql.org
> >
> >
> >
> >
> > I was just wondering why in the generated schema nextval is cast to text
> > rather than int?
> >
> >
> > John
> >
> > CREATE TABLE x (
> > id integer DEFAULT nextval('"x_id_seq"'::text) NOT NULL,
> > name character varying(30) NOT NULL
> > );
> >
> >
> >
> >
> >
> > Do you Yahoo!?
> > Yahoo! Tax Center - forms, calculators, tips, and more
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
