| From: | Nabil Sayegh <nsmail(at)sayegh(dot)de> |
|---|---|
| To: | Chris Smith <csmith(at)squiz(dot)net> |
| Cc: | postgresql <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: inserting values like in mySQL |
| Date: | 2001-05-23 01:36:08 |
| Message-ID: | 20010523013240.F298A14EE63@gerstung3.net-lab.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On 23 May 2001 09:24:02 +1000, Chris Smith wrote:
> What I meant was...
> You can do it, just not with int or serial values (try it with a text,
> varchar, char, bool field), or any field with the UNIQUE constraint. Same
> as mysql, you can't insert '' into an int field or an auto_increment field.
>
> Bye again :)
And what I meant was: When inserting NULL, or skipping a field =->
default.
But as you stated: sometimes it is desireable to insert NULL
BTW:
What I want, and what is good for me needn't be the same ;)
Using proprietary extensions isn't very portable.
--
Nabil Sayegh
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew McMillan | 2001-05-23 10:52:40 | Re: inserting values like in mySQL |
| Previous Message | Chris Smith | 2001-05-22 23:24:02 | Re: inserting values like in mySQL |