Re: [SQL] How do I run a search on array

2000-09-20 Thread Stephan Szabo
On Thu, 21 Sep 2000, Indraneel Majumdar wrote: > 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"}} You'll want to check out the array utilities in the contri

[SQL] How do I run a search on array

2000-09-20 Thread Indraneel Majumdar
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