> From: Stephan Szabo <[EMAIL PROTECTED]>
> > To: ohp@pyrenet.fr
> > Cc: pgsql-hackers list
> > Subject: Re: [HACKERS] how is that possible
> >
> >
> > On Fri, 10 Feb 2006 ohp@pyrenet.fr wrote:
> >
> > > My understanding is that null or not, there
Many thanks for explaining.
I learned something today...
On Fri, 10 Feb 2006, Stephan Szabo wrote:
> Date: Fri, 10 Feb 2006 08:59:51 -0800 (PST)
> From: Stephan Szabo <[EMAIL PROTECTED]>
> To: ohp@pyrenet.fr
> Cc: pgsql-hackers list
> Subject: Re: [HACKERS] how is that poss
On Fri, 10 Feb 2006 ohp@pyrenet.fr wrote:
> My understanding is that null or not, their should have been a foreign key
> violation.
Not as far as I can tell. MATCH (without partial or full) returns true if
any column in the row value constructor is NULL. MATCH FULL returns true
if all columns in
rs list
> Subject: Re: [HACKERS] how is that possible
>
>
> On Fri, 10 Feb 2006 ohp@pyrenet.fr wrote:
>
> > After a typo, I've just noticed the following :
> >
> > ~ 14:58:33: createdb test
> > CREATE DATABASE
> > ~ 14:58:42: psql test
> >
On Fri, 10 Feb 2006 ohp@pyrenet.fr wrote:
> After a typo, I've just noticed the following :
>
> ~ 14:58:33: createdb test
> CREATE DATABASE
> ~ 14:58:42: psql test
> Welcome to psql 8.1.2, the PostgreSQL interactive terminal.
>
> Type: \copyright for distribution terms
>\h for help with
ohp@pyrenet.fr wrote:
> test=# create table t1 (i int primary key);
> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "t1_pkey" for
> table "t1"
> CREATE TABLE
> test=# create table t2 (i int references t2 1 on deley te cascade on
> update cascade
> );
The t2.i column is null
After a typo, I've just noticed the following :
~ 14:58:33: createdb test
CREATE DATABASE
~ 14:58:42: psql test
Welcome to psql 8.1.2, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g
