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