Postgres Pro
Downloads
Home   >   mailing lists

Re: How to insert with a serial - Mailing list pgsql-general

From Tom Lane
Subject Re: How to insert with a serial
Date
Msg-id 26357.1003787333@sss.pgh.pa.us
Whole thread Raw
In response to Re: How to insert with a serial  ("Mitch Vincent" <mvincent@cablespeed.com>)
List pgsql-general
Tree view 
"Mitch Vincent" <mvincent@cablespeed.com> writes:
> insert 'ing a NULL in place of the serial will work too, yes?
> INSERT INTO DEVICES (my_serial_id, name, type, ownerteamid) VALUES
> (NULL,'scoobydoo', 1, 43);

No, that'll insert a NULL.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: where are the memory leaks?
Next
From: Martin Weinberg
Date:
Subject: Using an SMP machine to make multiple indices on the same table