Alias "all fields"?
От | Franz.Rasper@izb.de |
---|---|
Тема | Alias "all fields"? |
Дата | |
Msg-id | 11EC9A592C31034C88965C87AF18C2A702B83681@m0000s61 обсуждение исходный текст |
Ответы |
Re: Alias "all fields"?
|
Список | pgsql-general |
Hmm > SELECT * FROM gdp WHERE y1970 NOT NULL AND y1971 NOT NULL > AND .... y2005 NOT NULL It sounds like a bad table design, because i think you need an field "f_year" and "value_of_f_year" then there would be entries like f_year;value_of_f_year 1970 'NULL' 1970 dfgsd 1971 'NULL' 1971 .... where f_year IS NOT NULL and value_of_f_year IS NOT NULL Greetings, -Franz -----Ursprüngliche Nachricht----- Von: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] Im Auftrag von Stefan Schwarzer Gesendet: Donnerstag, 6. September 2007 13:43 An: pgsql-general@postgresql.org Betreff: [SPAM] [GENERAL] Alias "all fields"? 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/
В списке pgsql-general по дате отправления: