At 16:51 2001/08/09 +0200, Tony Grant wrote:
>festival | filmid
>------------------------------------------
>1979 | 102, 103, 104
>1980 | 258, 369, 489, 568
>
>How can I simulate an ARRAY of this type? If I can't - where is the
>nearest bridge?
you could define a table with this data:
festival | filmid
------------------------------------------
1979 | 102
1979 | 103
1979 | 104
1980 | 258
1980 | 369
1980 | 489
1980 | 568
with a query like this:
select filmid from films where festival = '1980'
and use a loop like this to generate an array
Vector films = new Vector();
while ( rs.next() )
{
films.add ( rs.getString ( "filmid" ) );
}
bye
John
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
