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
Herouth, thanks a lot for your answer. But I'm afraid I was rather unclear.
On 09-Jun-99 Herouth Maoz wrote:
> At 10:13 +0300 on 09/06/1999, Jeroen Schaap wrote:
>> Do you know of any way to generally convert arrays into query results?
>>
>> I know it is better to implement arrays as tables, bu
At 10:13 +0300 on 09/06/1999, Jeroen Schaap wrote:
> Do you know of any way to generally convert arrays into query results?
>
> I know it is better to implement arrays as tables, but that results in
> unreadable tables (with 10 rows with id=1, 15 with id=2, 2 with id=3 ad
> infundum...).
>
> So
Dear psql'ers,
Do you know of any way to generally convert arrays into query results?
I know it is better to implement arrays as tables, but that results in
unreadable tables (with 10 rows with id=1, 15 with id=2, 2 with id=3 ad
infundum...).
So is there any way to convert an array into a tab
