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@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] Im Auftrag von Stefan Schwarzer Gesendet: Donnerstag, 6. September 2007 13:43 An: pgsql-general@xxxxxxxxxxxxxx Betreff: [SPAM] 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/ ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
