| 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: | Whole Thread | Raw Message | 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.) |