Re: Alias "all fields"?

>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?

Normally i use perl with DBD/DBI to import data into databases and it is
quite
easy to modify raw data with perl and import them.

I would prefer another table design (your import will then not be so simple,
but your "selects" will get "normally" faster and easier).

Table:
id_Table;id_row;t_year;t_year_value
1;1;y1970,23
2;1;y1971;25
...
....
20;3;y1970;NULL
21;3;y1971;94

You will need only id_row if you need all tuples in the same line of your
original line.

I yould do it so, if you have more then 3 or 4 columns of y???? .

Greetings,

-Franz