Select from array slices doesn't work

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: Select from array slices doesn't work
Date: 2000-09-07 15:56:30
Message-ID: 200009071556.e87FuUL55499@hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Kuba Ober (winnie(at)mika(dot)fr(dot)eu(dot)org) reports a bug with a severity of 2
The lower the number the more severe it is.

Short Description
Select from array slices doesn't work

Long Description
When I try to select from array slices it gives strange qrPgSql error. Normal array indexing works, but slices don't.

Sample Code
> create table temp (arr varchar(20)[])
OK
> select arr[1:2] from temp
Error: qrPgSql: Parameter '2' not found
> select arr[1] from temp
OK

No file was uploaded with this report

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2000-09-07 23:51:15 Re: bug in date_part() function in 6.5.2, 7.0.2
Previous Message Thomas Lockhart 2000-09-07 14:22:41 Re: bug in date_part() function in 6.5.2, 7.0.2