From: | Indraneel Majumdar <indraneel(at)www(dot)cdfd(dot)org(dot)in> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | How do I run a search on array |
Date: | 2000-09-21 16:29:34 |
Message-ID: | Pine.SGI.3.96.1000921092140.143793B-100000@www.cdfd.org.in |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general 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(at)123india(dot)com #
# Bioinformatics Unit (EMBNET node), ¡ URL: http://scorpius.iwarp.com #
# Centre for DNA Fingerprinting and Diagnostics, #
# Hyderabad, India - 500076 #
`************************************************************************/
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2000-09-21 16:59:46 | Re: replication |
Previous Message | Edward Q. Bridges | 2000-09-21 15:11:25 | Re: perl Pg module and result status |
From | Date | Subject | |
---|---|---|---|
Next Message | Brian C. Doyle | 2000-09-21 17:12:41 | Multiple Index's |
Previous Message | Frank Bax | 2000-09-21 15:50:10 | Re: [Fwd: Re: no ORDER BY in subselects?] |