How do I run a search on array

Поиск
Список
Период
Сортировка
От Indraneel Majumdar
Тема How do I run a search on array
Дата
Msg-id Pine.SGI.3.96.1000921092140.143793B-100000@www.cdfd.org.in
обсуждение исходный текст
Ответ на Re: [GENERAL] Foreign Keys Help Delete!  (Timothy Covell <dirac@applink.net>)
Ответы Re: How do I run a search on array
Список 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                                              #
`************************************************************************/



В списке pgsql-sql по дате отправления:

Предыдущее
От: Timothy Covell
Дата:
Сообщение: Re: [GENERAL] Foreign Keys Help Delete!
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: How do I run a search on array