nextval::text - Mailing list pgsql-general

From John Smith
Subject nextval::text
Date
Msg-id 20030305065434.15404.qmail@web40706.mail.yahoo.com
Whole thread Raw
Responses Re: nextval::text  (Martijn van Oosterhout <kleptog@svana.org>)
Re: nextval::text  (Dennis Gearon <gearond@cvc.net>)
List pgsql-general

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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Help with installation and config, Missing file...
Next
From: Dennis Gearon
Date:
Subject: Re: Demande d'information