Postgres Pro
Downloads
Home   >   mailing lists

Re: select all rows where any column is NULL - Mailing list pgsql-general

From Merlin Moncure
Subject Re: select all rows where any column is NULL
Date
Msg-id CAHyXU0y0jL857pQ-Sw+FMMwS5tB9PxFLKUpFAdnBRcxouMSxpg@mail.gmail.com
Whole thread Raw
In response to select all rows where any column is NULL  (Nathan Boley <npboley@gmail.com>)
List pgsql-general
Tree view 
On Tue, Jul 26, 2011 at 2:08 PM, Nathan Boley <npboley@gmail.com> wrote:
> Does anyone have a concise way of doing $SUBJECT?

 select * from foo where (row((foo).*) = row((foo).*)) is null;

merlin

pgsql-general by date:

Previous
From: Radosław Smogura
Date:
Subject: Re: variant column type
Next
From: Radosław Smogura
Date:
Subject: Re: 100 times faster than mysql