selecting array slice problem

From: Alex Jiang <ajiangenator(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org(dot)
Subject: selecting array slice problem
Date: 2006-01-20 01:34:29
Message-ID: aa4a552a0601191734n6b0fc86bn5f0fe20cfc5df33f@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rich Shepard 2006-01-20 01:45:51 Re: Upgrade Problem: 7.4.3 -> 8.1.2
Previous Message Rich Shepard 2006-01-20 01:02:23 Re: Upgrade Problem: 7.4.3 -> 8.1.2