Received: from janus.hosting4u.net (janus.hosting4u.net [209.15.2.37]) by hub.org (8.10.1/8.10.1) with SMTP id e5G4hOI06197 for ; Fri, 16 Jun 2000 00:43:24 -0400 (EDT) Received: (qmail 19676 invoked from network); 16 Jun 2000 04:43:25 -0000 Received: from aquarius.hosting4u.net (HELO jfca.com) (209.15.2.40) by mail-gate.hosting4u.net with SMTP; 16 Jun 2000 04:43:25 -0000 Received: from thekeep ([12.22.49.224]) by jfca.com ; Thu, 15 Jun 2000 23:43:21 -0500 From: James Carpenter Reply-To: jamesc@jfca.com Organization: J.F. Carpenter & Associates, Inc. To: pgsql-sql@postgresql.org Subject: Determining Array size Date: Thu, 15 Jun 2000 23:41:14 -0700 X-Mailer: KMail [version 1.0.29] Content-Type: text/plain MIME-Version: 1.0 Message-Id: <00061523471000.00856@thekeep> Content-Transfer-Encoding: 8bit X-Archive-Number: 200006/160 I am trying to determine the number of elements in an array. I looked through the list of loaded functions, and was unable to find one that seemed to provide this functionality. Is there some other means to detemine this? I am new to postgresql and am still trying to learn the 'ordbms way' :-) thanks, - james - --------------------------------------------------------------------- PostgreSQL 7.0.1 on i686-pc-linux-gnu, compiled by gcc egcs-2.91.66