Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group