How do I run a search on array - Mailing list pgsql-sql

Hi,

I've been trying to do:

select col1 from table while array_col[1][1:4]='2';

how do I do this sort of thing? There seems to be no docs ;-(

my array is {{"1","2","4","2"},{"3","2","5"},{"6","3","7","9"}}

I would also like to know that if I have an array as a large object, is it
possible to do a search on it using rows and columns (or by any other
way)?

thanks,
Indraneel

/************************************************************************.
# Indraneel Majumdar                  ¡  E-mail: indraneel@123india.com  #
# Bioinformatics Unit (EMBNET node),  ¡  URL: http://scorpius.iwarp.com  #
# Centre for DNA Fingerprinting and Diagnostics,                         #
# Hyderabad, India - 500076                                              #
`************************************************************************/