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