[GENERAL] selecting array slice problem

[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 the colon is a name for a field.
I am using Postgresql 8.0-beta1 and my application is written in Delphi 5.  I access the database through the BDE.
Is there any solution to this.
Thank you for all your help.

Alex