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