On 4/3/06, Ottavio Campana <ottavio(at)campana(dot)vi(dot)it> wrote:
> 3) faq 4.11.1 says
>
> > CREATE TABLE person (
> > id SERIAL,
> > name TEXT
> > );
> >
> >is automatically translated into this:
> >
> > CREATE SEQUENCE person_id_seq;
> > CREATE TABLE person (
> > id INT4 NOT NULL DEFAULT nextval('person_id_seq'),
> > name TEXT
> > );
>
> how can I do it with a INT8 instead of a INT4?
>
> Thank you
>
Is there a reason not to write explicitly?
CREATE SEQUENCE person_id_seq;
CREATE TABLE person (
id INT8 NOT NULL DEFAULT nextval('person_id_seq'),
name TEXT
);
Tomislav