Re: Alias "all fields"?

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