Re: [HACKERS] empty/automatic insert availability - Mailing list pgsql-hackers

From Thomas Lockhart
Subject Re: [HACKERS] empty/automatic insert availability
Date
Msg-id 3806B3DA.95DEF831@alumni.caltech.edu
Whole thread Raw
In response to empty/automatic insert availability  (Daniel Péder <dpeder@infoset.cz>)
List pgsql-hackers
> it would be good idea to enable "empty automatic insert" like this:
> mydb => create table pgx_replid ( repltime time DEFAULT current_time );
> mydb => insert into pgx_replid;
> the above should insert the value of current_time into database pgx_replid, however it is 
> impossible yet (ver.6.3.x / 6.5.2).

Not true :)

We support the SQL92-standard syntax:
 mydb => insert into pgx_replid default values;

Have fun with it...
               - Thomas

-- 
Thomas Lockhart                lockhart@alumni.caltech.edu
South Pasadena, California


pgsql-hackers by date:

Previous
From: Thomas Lockhart
Date:
Subject: Re: can postgres do this?
Next
From: Bruce Momjian
Date:
Subject: int8