ERROR: cannot subscript type text because it is not an array - Mailing list pgsql-sql

From lxnf98mm@comcast.net
Subject ERROR: cannot subscript type text because it is not an array
Date
Msg-id alpine.LRH.2.00.1108310820490.21634@rray.drdc.mstc.ms.gov
Whole thread Raw
List pgsql-sql
I have table with field l type lseg
 Column |  Type   | Modifiers
--------+---------+----------- cnt    | integer | used   | boolean | l      | lseg    | c      | text    |

select l from t where used = false group by l[0];
ERROR:  cannot subscript type text because it is not an array

select l from gcode where used = false group by l[0][0],l[0][1];
ERROR:  cannot subscript type text because it is not an array


Using PostgreSQL 8.3.11
How can I work around this

Richard


pgsql-sql by date:

Previous
From: Emi Lu
Date:
Subject: Re: where col1 not ilike ('str1%', 'str2%'... 'strN%') support?
Next
From: Pavel Stehule
Date:
Subject: Re: where col1 not ilike ('str1%', 'str2%'... 'strN%') support?