Re: [GENERAL] Howto convert arrays 2 query results

On 10-Jun-99 Gerald Fiedler wrote:

> create table relation (S_ID int, M_ID int);
> insert into relation (2,1);
> insert into relation (4,1);
> insert into relation (1,2);
> insert into relation (3,2);
>
> will normalize your DB, so you don't need an array.

Yes, it sure will.

But only, I don't want to break up the arrays because the tables become
unreadible when I have to add 15 solutions to a particular medium. And I try
to keep the tables editable by hand.

So I thought it would be possible to make a function that converts an array
to a query result. But I really don't know whether this could be practically
possible. I'm not too effluent in c, so I wanted to ask before I start to
write code and duplicate something that already exists....

Thanks a lot,


Jeroen

---
Jeroen Schaap.............I was dreaming of guitarnotes that would irritate
Homepage: <http://rulffh.medfac.leidenuniv.nl>..| ^|^ |...an executive kind
Keywords: Guitars, Linux, Mac and SCN...........\_`-'_/..............of guy
Tel: (0)71-5276811................................| |...........Frank Zappa