Re: [GENERAL] selecting array slice problem

2006-01-19 Thread Michael Fuhr
On Thu, Jan 19, 2006 at 05:34:29PM -0800, Alex Jiang wrote: > I'm trying to access a bit array field that is declared as > > sp1 bit[][] > > When I attempt to access a slice of the array with the following command: > > SELECT sp1[1:2][1] > > I get the error: ' Field '2][1]' is of an unknown typ

[GENERAL] selecting array slice problem

2006-01-19 Thread Alex Jiang
Hi, Please help. I'm trying to access a bit array field that is declared as sp1 bit[][] When I attempt to access a slice of the array with the following command: SELECT sp1[1:2][1] I get the error: ' Field '2][1]' is of an unknown type'. Postgre seems to think that the characters following th