Re: quastions about primary key

From: Tomasz Myrta <jasiek(at)klaster(dot)net>
To: jack <datactrl(at)tpg(dot)com(dot)au>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: quastions about primary key
Date: 2003-01-24 10:04:07
Message-ID: 3E310F97.5050207@klaster.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message daq 2003-01-24 10:28:35 Re: CAST from VARCHAR to INT
Previous Message David Durst 2003-01-24 08:45:38 Re: Scheduling Events?