Re: [SQL] quastions about primary key

2003-01-24 Thread Tomasz Myrta
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,

Re: [SQL] quastions about primary key

2003-01-24 Thread Stephan Szabo
On Fri, 24 Jan 2003, jack wrote: Is that possible to have a two columns primary key on a table with null value on second column? No, because primary key implies not null on all columns involved (technically I think it's that a non-deferrable primary key implies not null on all columns

[SQL] quastions about primary key

2003-01-23 Thread jack
Is that possible to have a two columns primary key on a table with null value on second column? Jack ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so