On Thu, Aug 13, 2009 at 11:44 PM, Daniel Verite<daniel@xxxxxxxxxxxxxxxx> wrote: >> In other discussions about similar issues I've said that the expression: >> >> ROW(NULL,NULL) IS DISTINCT FROM NULL >> >> should evaluate to FALSE. I still think this is correct and generally >> useful behavior. > > I see no reason to disagree with this. Besides, the fact that > ROW(NULL,NULL) IS DISTINCT FROM NULL evaluates to true > while ROW(NULL,NULL) IS NULL also evaluates to true > looks quite puzzling to me. Why is this thread still going on? What does the spec say we should be doing and are we violating it in any of these cases? -- greg http://mit.edu/~gsstark/resume.pdf -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
