Array-Handling: use in subselect, push ...

Hi,

I'm new on this list, so if the questions are better on some other
lists, please let me know!

Are there somewhere detailed informations about arrays?

Has Postgres some special array functions like push, shift, unshift ...
in Perl?

How it is possible to use arrays in subselects? I tested it with this
statement, but it's wrong:

SELECT foo, bar FROM data_table
WHERE id IN
(SELECT my_super_list FROM xyz_table WHERE id = 123)

I'm using Postgres 7, Perl 5.6/mod_perl and the DBI-Interface.

Thanks and Ciao
Alvar

--
Alvar C.H. Freude | alvar(dot)freude(at)merz-akademie(dot)de

Demo: http://www.online-demonstration.org/ | Mach mit!
Blast-DE: http://www.assoziations-blaster.de/ | Blast-Dich-Fit
Blast-EN: http://www.a-blast.org/ | Blast/english