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

Re: "NOT NULL"

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: tövis <tovises(at)freemail(dot)hu>
Cc: pgsql novice <pgsql-novice(at)postgresql(dot)org>,"Jan B(dot)" <jan(at)monso(dot)de>
Subject: Re: "NOT NULL"
Date: 2005-05-24 17:20:20
Message-ID: 20050524172020.GB8129@wolff.to (view raw or flat)
Thread:
Lists: pgsql-novice
On Tue, May 24, 2005 at 14:40:00 +0200,
  tövis <tovises(at)freemail(dot)hu> wrote:
> covering and completelly hide the ODBC/SQL surface. It is also object 
> oriented and I cannot give string value for an integer (especially if its 
> length only 4 byte instead of 7 characzter such as 'DEFAULT'). This is why 

You aren't supposed to be using "'DEFAULT'", but rather "DEFAULT". It is
a keyword, not a value. It still may be that your software won't let
you use it. Using an explicit column list and leaving off the serial
field is probably your best bet.

In response to

pgsql-novice by date

Next:From: Keith WorthingtonDate: 2005-05-24 18:02:40
Subject: UPDATE with JOIN
Previous:From: Tom LaneDate: 2005-05-24 17:13:39
Subject: Re: Sparse Data

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