Re: [GENERAL] Howto convert arrays 2 query results - Mailing list pgsql-general

From Jeroen Schaap
Subject Re: [GENERAL] Howto convert arrays 2 query results
Date
Msg-id XFMail.990610132601.jeroen@rulffh.medfac.leidenuniv.nl
Whole thread Raw
In response to Re: [GENERAL] Howto convert arrays 2 query results  (Gerald Fiedler <gerald@interface-business.de>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Gerald Fiedler
Date:
Subject: Re: [GENERAL] Howto convert arrays 2 query results
Next
From: Adriaan Joubert
Date:
Subject: new type: 1-byte bit mask type