RE: tough one

Tony,

Offhand, I would say you need to wrap this with some code which takes an
array, and stores it comma separated, and vice versa.

This is a pretty simple solution, is there something I am missing?

Dave
-----Original Message-----
From: pgsql-jdbc-owner@postgresql.org
[mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Tony Grant
Sent: August 9, 2001 10:52 AM
To: pgsql-jdbc@postgresql.org
Subject: [JDBC] tough one


Todays impossible question =:-D

I really need an ARRAY but I am stuck with JDBC 1.0.

the table looks like this

festival	| filmid
------------------------------------------
1979		| 102, 103, 104
1980		| 258, 369, 489, 568

ad nauseum

How can I simulate an ARRAY of this type? If I can't - where is the
nearest bridge?

Cheers

Tony Grant


-- 
RedHat Linux on Sony Vaio C1XD/S
http://www.animaproductions.com/linux2.html
Macromedia UltraDev with PostgreSQL
http://www.animaproductions.com/ultra.html


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://www.postgresql.org/search.mpl