Postgres Pro
Downloads
Home   >   mailing lists

Find NOT NULLs in a group of 20 columns - Mailing list pgsql-sql

From gvim
Subject Find NOT NULLs in a group of 20 columns
Date
Msg-id 4D2BBCF4.8070905@gmail.com
Whole thread Raw
Responses Re: Find NOT NULLs in a group of 20 columns
List pgsql-sql
Tree view 
I'm struggling to find anything other than a complex stored proc to do this:

Out of a group of 20 columns return the rows in which:

1. Only 1 of the 20 columns IS NOT NULL
2. More than 1 of the 20 columns IS NOT NULL

Any ideas?

gvim

pgsql-sql by date:

Previous
From: Jasen Betts
Date:
Subject: Re: pattern matching with dates?
Next
From: Tom Lane
Date:
Subject: Re: Find NOT NULLs in a group of 20 columns