Re: nextval::text

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(at)yahoo(dot)com> wrote:
>
> >
> >
> > Date: Tue, 4 Mar 2003 22:54:34 -0800 (PST)
> >
> > From: John Smith <john_smith_45678(at)yahoo(dot)com>
> > Subject:[GENERAL] nextval::text
> > To: pgsql-general(at)postgresql(dot)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(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073