Alias "all fields"?

Поиск
Список
Период
Сортировка
От Stefan Schwarzer
Тема Alias "all fields"?
Дата
Msg-id 7DB62B0B-31D8-46C8-ABDC-5A4F3D82AFEE@grid.unep.ch
обсуждение исходный текст
Ответы 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>)
Список 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 по дате отправления:

Предыдущее
От: Nis Jørgensen
Дата:
Сообщение: Re: Need suggestion on how best to update 3 million rows
Следующее
От: Franz.Rasper@izb.de
Дата:
Сообщение: Alias "all fields"?