Stefan Schwarzer schrieb:
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
My table design is - due to some import/update reasons - surely not the
best one, but pretty simple:
id y1970 y1971 y1972 ......
1 23 25 28
2 NULL NULL 5
3 NULL 94 102
What do you think?
Make the table:
id | year | value
---+------+------
1 | 1970 | 23
1 | 1971 | 25
1 | 1972 | 28
...
2 | 1972 | 5
3 | 1971 | 94
3 | 1972 | 102
primary key: (id,year)
value not null
and be ready.
the import/update reasons are pretty easily solved
that way too.
Regards
Tino
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
