Postgres Pro
Downloads
Home   >   mailing lists

Re: quastions about primary key - Mailing list pgsql-sql

From Tomasz Myrta
Subject Re: quastions about primary key
Date
Msg-id 3E310F97.5050207@klaster.net
Whole thread Raw
In response to quastions about primary key  ("jack" <datactrl@tpg.com.au>)
List pgsql-sql
Tree view 
jack wrote:
> Is that possible to have a two columns primary key on a table with null
> value on second column?
> 
> Jack
Probably not, because (1,2,null,null) is unique for postresql.
Watch discussion on mailing list
about unique indexes (on which primary key is based) several days ago.

Regards,
Tomasz Myrta

pgsql-sql by date:

Previous
From: daq
Date:
Subject: Re: CAST from VARCHAR to INT
Next
From: Bruno Wolff III
Date:
Subject: Re: Scheduling Events?