Thread: selecting array slice problem
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
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
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 type'. Is that the exact error message? I can't find it anywhere in the source code so I suspect it's an error from your client library. > Postgre seems to think that the characters following the colon is a name for > a field. Works here in 8.0.6: test=> CREATE TABLE foo (sp1 bit[][]); CREATE TABLE test=> INSERT INTO foo VALUES ('{{0,1},{1,0}}'); INSERT 0 1 test=> SELECT sp1[1:2][1] FROM foo; sp1 ----------- {{0},{1}} (1 row) > I am using Postgresql 8.0-beta1 and my application is written in Delphi 5. Release versions of 8.0 have been available for a year and the latest is 8.0.6. Running an old early beta isn't a good idea; lots of bugs have been fixed since then. > I access the database through the BDE. What happens if you run the same query in psql? If it works in psql then the problem is likely with Delphi. -- Michael Fuhr