Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 2898FB5DC23 for ; Wed, 31 Aug 2011 10:27:23 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 37731-05 for ; Wed, 31 Aug 2011 13:27:17 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from qmta15.westchester.pa.mail.comcast.net (qmta15.westchester.pa.mail.comcast.net [76.96.59.228]) by mail.postgresql.org (Postfix) with ESMTP id DEC21B5DC0F for ; Wed, 31 Aug 2011 10:27:16 -0300 (ADT) Received: from omta07.westchester.pa.mail.comcast.net ([76.96.62.59]) by qmta15.westchester.pa.mail.comcast.net with comcast id T0Rt1h0011GhbT85F1THuF; Wed, 31 Aug 2011 13:27:17 +0000 Received: from rray2.comcast.net ([75.65.154.18]) by omta07.westchester.pa.mail.comcast.net with comcast id T1TG1h0040Q4uCT3T1TG9M; Wed, 31 Aug 2011 13:27:17 +0000 Received: from rray.drdc.mstc.ms.gov ([172.17.32.9]) by rray2.comcast.net (8.14.3/8.14.3/Debian-9.1ubuntu1) with ESMTP id p7VDR8Kv007368 for ; Wed, 31 Aug 2011 08:27:09 -0500 Received: from rray.drdc.mstc.ms.gov (rray.drdc.mstc.ms.gov [127.0.0.1]) by rray.drdc.mstc.ms.gov (8.13.8/8.13.8) with ESMTP id p7VDQveF023359 for ; Wed, 31 Aug 2011 08:26:57 -0500 Received: from localhost (rray@localhost) by rray.drdc.mstc.ms.gov (8.13.8/8.13.8/Submit) with ESMTP id p7VDQvCS023356 for ; Wed, 31 Aug 2011 08:26:57 -0500 X-Authentication-Warning: rray.drdc.mstc.ms.gov: rray owned process doing -bs Date: Wed, 31 Aug 2011 08:26:57 -0500 (CDT) From: lxnf98mm@comcast.net X-X-Sender: rray@rray.drdc.mstc.ms.gov To: pgsql-sql@postgresql.org Subject: ERROR: cannot subscript type text because it is not an array Message-ID: User-Agent: Alpine 2.00 (LRH 1167 2008-08-23) MIME-Version: 1.0 Content-Type: TEXT/PLAIN; format=flowed; charset=US-ASCII X-Virus-Scanned: clamav-milter 0.96.5 at rray2 X-Virus-Status: Clean X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.393 tagged_above=-5 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, RCVD_IN_DNSWL_NONE=-0.0001, RP_MATCHES_RCVD=-0.504, T_TO_NO_BRKTS_FREEMAIL=0.01 X-Spam-Level: X-Archive-Number: 201108/128 X-Sequence-Number: 35796 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