selecting array slice problem - Mailing list pgsql-general

From Alex Jiang
Subject selecting array slice problem
Date
Msg-id aa4a552a0601191734n6b0fc86bn5f0fe20cfc5df33f@mail.gmail.com
Whole thread Raw
Responses Re: selecting array slice problem
List pgsql-general
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

pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Re: Upgrade Problem: 7.4.3 -> 8.1.2
Next
From: Rich Shepard
Date:
Subject: Re: Upgrade Problem: 7.4.3 -> 8.1.2