nextval::text

From: John Smith <john_smith_45678(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: nextval::text
Date: 2003-03-05 06:54:34
Message-ID: 20030305065434.15404.qmail@web40706.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Emmanuel Charpentier 2003-03-05 07:28:49 [OT] : the mailing lists-newsgroup seems to be out of commission.
Previous Message Jeff Davis 2003-03-05 05:18:36 Re: Why PostgreSQL?