Re: select all rows where any column is NULL

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: Nathan Boley <npboley(at)gmail(dot)com>
Cc: PostgreSQL general <pgsql-general(at)postgresql(dot)org>
Subject: Re: select all rows where any column is NULL
Date: 2011-07-26 19:53:35
Message-ID: CAHyXU0y0jL857pQ-Sw+FMMwS5tB9PxFLKUpFAdnBRcxouMSxpg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Jul 26, 2011 at 2:08 PM, Nathan Boley <npboley(at)gmail(dot)com> wrote:
> Does anyone have a concise way of doing $SUBJECT?

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

merlin

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Radosław Smogura 2011-07-26 19:58:24 Re: 100 times faster than mysql
Previous Message Radosław Smogura 2011-07-26 19:48:14 Re: variant column type