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 -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
