Alias "all fields"?

From: Stefan Schwarzer <stefan(dot)schwarzer(at)grid(dot)unep(dot)ch>
To: pgsql-general(at)postgresql(dot)org
Subject: Alias "all fields"?
Date: 2007-09-06 11:43:25
Message-ID: 7DB62B0B-31D8-46C8-ABDC-5A4F3D82AFEE@grid.unep.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi there,

I guess I am demanding too much.... But it would be cool to have some
kind of alias for "all fields".

What I mean is this here:

Instead of this:

SELECT * FROM gdp WHERE y1970 NOT NULL AND y1971 NOT NULL
AND .... y2005 NOT NULL

I would like to have this:

SELECT * FROM gdp WHERE all-fields NOT NULL

This is, because my tables have different - and a different number of
fields.

In principal, I actually just want to have the number of fields which
are NOT NULL...

Thanks for any advice.

Stef

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Franz.Rasper 2007-09-06 11:51:58 Alias "all fields"?
Previous Message Nis Jørgensen 2007-09-06 11:39:51 Re: Need suggestion on how best to update 3 million rows