empty/automatic insert availability

From: Daniel Péder <dpeder(at)infoset(dot)cz>
To: "'pgsql-hackers(at)postgresql(dot)org'" <pgsql-hackers(at)postgresql(dot)org>
Subject: empty/automatic insert availability
Date: 1999-10-12 19:31:24
Message-ID: 01BF14F0.C158EBC0@Dan
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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). Now, everytime needed, one should type more complex lines like:

mydb => insert into pgx_replid values ( current_time );

====
in case the table was created without any DEFAULT the empty insert should insert NULL or NULLs into all (or specified) fields of table as the general behavior.

--
dan peder
dpeder(at)infoset(dot)cz

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 1999-10-12 19:37:39 Re: New developer globe (was: Re: [HACKERS] Interesting Quote you might
Previous Message Oleg Bartunov 1999-10-12 19:28:48 Re: New developer globe (was: Re: [HACKERS] Interesting Quote you might enjoy about PGSQL.)