Alias "all fields"? - Mailing list pgsql-general

From Stefan Schwarzer
Subject Alias "all fields"?
Date
Msg-id 7DB62B0B-31D8-46C8-ABDC-5A4F3D82AFEE@grid.unep.ch
Whole thread Raw
Responses Re: Alias "all fields"?  (Richard Huxton <dev@archonet.com>)
Re: Alias "all fields"?  (Tino Wildenhain <tino@wildenhain.de>)
Re: Alias "all fields"?  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Alias "all fields"?  ("George Pavlov" <gpavlov@mynewplace.com>)
List 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


pgsql-general by date:

Previous
From: Nis Jørgensen
Date:
Subject: Re: Need suggestion on how best to update 3 million rows
Next
From: Franz.Rasper@izb.de
Date:
Subject: Alias "all fields"?