From: | "Jackson, DeJuan" <djackson(at)cpsgroup(dot)com> |
---|---|
To: | Hroi Sigurdsson <hroi(at)ninja(dot)dk> |
Cc: | pgsql-sql(at)postgreSQL(dot)org |
Subject: | RE: [SQL] DEFAULT confusion |
Date: | 1999-09-08 18:08:23 |
Message-ID: | D05EF808F2DFD211AE4A00105AA1B5D2519AB6@cpsmail |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
> -----Original Message-----
> From: Hroi Sigurdsson [SMTP:hroi(at)ninja(dot)dk]
> Sent: Tuesday, September 07, 1999 9:40 PM
> To: pgsql-sql(at)postgreSQL(dot)org
> Subject: [SQL] DEFAULT confusion
>
> Hello postgresql'ers (how do you pronounce that?).
>
> Suppose i have the following sequence, table and index:
>
> CREATE SEQUENCE stuff_seq;
> CREATE TABLE stuff (
> id INTEGER DEFAULT NEXTVAL('stuff_seq') NOT NULL,
> name TEXT,
> number INTEGER
> );
> CREATE UNIQUE INDEX stuff_id ON tabel(id);
>
> Then to properly insert rows i have to
>
> INSERT INTO tabel VALUES (NEXTVAL('tabel_seq'), "sometext", 123);
Change the above line to:
INSERT INTO stuff(name, number) VALUES ('sometext', 123);
Hope this helps,
DEJ
> I can't just
> INSERT INTO tabel VALUES (NULL, "something", 123);
>
> Then what is the point of the DEFAULT clause? In other words: How do I
> get away with not specifying anything for id? And how (if
> possible/recommendable) do I force the id value to be nothing but
> NEXTVAL('stuff_seq'), ie. not just an arbitrary number?
>
> In short I want to emulate MySQL's way of doing
> CREATE TABLE(
> id INT NOT NULL AUTO_INCREMENT,
> name TEXT,
> int INT,
> UNIQUE(id)
> );
>
> I hope I made myself sufficiently clear.
>
> Thank you for your time.
>
>
> PS.
> Where can I get more information about the REFERENCES keyword and when
> will it be fully working in Postgres?
> PPS.
> Are there any books out there that cover Postgresql?
> --
> Hroi Sigurdsson
> hroi(at)ninja(dot)dk
>
> ************
From | Date | Subject | |
---|---|---|---|
Next Message | secret | 1999-09-09 20:03:19 | Re: [SQL] Type Conversion: int4 -> Money |
Previous Message | Hroi Sigurdsson | 1999-09-08 17:29:05 | Re: [SQL] DEFAULT confusion |