| From: | "Rod Taylor" <rod(dot)taylor(at)inquent(dot)com> |
|---|---|
| To: | "Hackers List" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | INSERT Issues |
| Date: | 2001-04-05 23:16:49 |
| Message-ID: | 022c01c0be97$d1efd9b0$2205010a@jester |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
CREATE TABLE junk (
col SERIAL PRIMARY KEY
);
INSERT INTO junk (col) DEFAULT VALUES;
INSERT INTO junk DEFAULT VALUES:
Second insert works, first one fails.
INSERT INTO table [ ( column [, ...] ) ]
{ DEFAULT VALUES | VALUES ( expression [, ...] ) | SELECT query }
The column list should just be ignored correct?
--
Rod Taylor
There are always four sides to every story: your side, their side, the
truth, and what really happened.
| Attachment | Content-Type | Size |
|---|---|---|
| Taylor, Rod B.vcf | text/x-vcard | 451 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rod Taylor | 2001-04-05 23:27:45 | Foreign Key & Rule confusion WAS: Lost Trigger(s)? |
| Previous Message | Henry B. Hotz | 2001-04-05 23:15:20 | Re: Call for platforms |