Skip site navigation (1) Skip section navigation (2)

Re: inserting values like in mySQL

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 (view raw or flat)
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



In response to

pgsql-novice by date

Next:From: Andrew McMillanDate: 2001-05-23 10:52:40
Subject: Re: inserting values like in mySQL
Previous:From: Chris SmithDate: 2001-05-22 23:24:02
Subject: Re: inserting values like in mySQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group