Re: [GENERAL] Getting multiple field unique index to distinguish NULLs.

1999-09-14 Thread Stuart Rison
On Fri, 10 Sep 1999, Tom Lane wrote: > Stuart Rison <[EMAIL PROTECTED]> writes: > > Now this would work except that there's a problem with pl/pgSQL such that > > when you pass several values to a plpgsql function and one of them is > > NULL, then all values passed to the function become NULL. >

RE: [GENERAL] Getting multiple field unique index to distinguish NULLs.

1999-09-14 Thread Stuart Rison
On Fri, 10 Sep 1999, omid omoomi wrote: > hi evey body, > I've some comments : > 1) I believe that there are some problems in table and db design and you are > doing the job in its hard way! There seems to be no primarry key defined on > the table. you can compose it at the end of your DDL(crea