pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Hroi Sigurdsson <hroi@ninja.dk>
To: pgsql-sql@postgresql.org
Subject: DEFAULT confusion
Date: Wed, 08 Sep 1999 02:39:46 +0000
Message-ID: <37D5CC72.9A7CBD49@ninja.dk> (raw)

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);

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@ninja.dk



view thread (9+ messages)  latest in thread

Message-ID: <37D5CC72.9A7CBD49@ninja.dk>
Permalink:  ../37D5CC72.9A7CBD49@ninja.dk/
Also on:    postgresql.org/message-id/37D5CC72.9A7CBD49@ninja.dk

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: hroi@ninja.dk
  Subject: Re: DEFAULT confusion
  In-Reply-To: <37D5CC72.9A7CBD49@ninja.dk>
  References: <37D5CC72.9A7CBD49@ninja.dk>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox