From: | Jeroen Schaap <jeroen(at)rulffh(dot)medfac(dot)leidenuniv(dot)nl> |
---|---|
To: | Gerald Fiedler <gerald(at)interface-business(dot)de> |
Cc: | pgsql-general(at)postgreSQL(dot)org, Herouth Maoz <herouth(at)oumail(dot)openu(dot)ac(dot)il> |
Subject: | Re: [GENERAL] Howto convert arrays 2 query results |
Date: | 1999-06-10 11:26:01 |
Message-ID: | XFMail.990610132601.jeroen@rulffh.medfac.leidenuniv.nl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Adriaan Joubert | 1999-06-10 11:41:49 | new type: 1-byte bit mask type |
Previous Message | Gerald Fiedler | 1999-06-10 11:06:44 | Re: [GENERAL] Howto convert arrays 2 query results |