Re: inserting values like in mySQL - Mailing list pgsql-novice

From Nabil Sayegh
Subject Re: inserting values like in mySQL
Date
Msg-id 20010523013240.F298A14EE63@gerstung3.net-lab.net
Whole thread Raw
In response to Re: inserting values like in mySQL  (Chris Smith <csmith@squiz.net>)
List 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



pgsql-novice by date:

Previous
From: Chris Smith
Date:
Subject: Re: inserting values like in mySQL
Next
From: Andrew McMillan
Date:
Subject: Re: inserting values like in mySQL