On May 1, 10:48 pm, t...@xxxxxxxxxxxxx (Tom Lane) wrote: > Ketema <ket...@xxxxxxxxx> writes: > > Is it possible to access a subarray of a multi dimensional array as a > > whole? > > I think you want an array slice (ie, something with some colons in the > subscripts). See the manual:http://www.postgresql.org/docs/8.2/static/arrays.html > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majord...@xxxxxxxxxxxxxx so that your > message can get through to the mailing list cleanly OK, sorry I missed that. still not sure I understand even after reading that. for my above example I would then use: select case when 1 = any(_intarray[1:1][1:1]) then true else false end; ? and it should return true since a 1 exists in that first subarray? thanks
