Re: [SQL] quastions about primary key

I try use uique instead of primary key. And it works, it allows null values. Is there any other difference between primary key and unique? Jack - Original Message - From: "Stephan Szabo" <[EMAIL PROTECTED]> To: "jack" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Saturday, January 25,

Re: [SQL] returning setof in plpgsql

I thought we had an example of this type of function in the docs, but we don't. Here is one: http://www.brasileiro.net:8080/postgres/cookbook/view-recipes.adp?section_id=535&format=long --- Tom Lane wrote: > "Davi

Re: [SQL] quastions about primary key

On Sun, Jan 26, 2003 at 12:29:12 +1000, jack <[EMAIL PROTECTED]> wrote: > > I try use uique instead of primary key. And it works, it allows null values. > Is there any other difference between primary key and unique? I believe that the primary key is the default key for foreign key references i