Return-Path: owner-postman Received: from localhost (localhost [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id HAA00565 for postgres-dist; Tue, 29 Mar 1994 07:27:57 -0800 Resent-From: POSTGRES mailing list Resent-Message-Id: <199403291527.HAA00565@nobozo.CS.Berkeley.EDU> X-Authentication-Warning: nobozo.CS.Berkeley.EDU: Host localhost didn't use HELO protocol Sender: owner-postman@postgres.Berkeley.EDU X-Return-Path: owner-postman Received: from vaxd.dct.ac.uk (vaxd.dct.ac.uk [193.60.160.96]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id HAA00551 for ; Tue, 29 Mar 1994 07:27:52 -0800 Received: by vaxd.dct.ac.uk (MX V3.3 VAX) id 12809; Tue, 29 Mar 1994 16:27:42 GMT Date: Tue, 29 Mar 1994 16:27:24 GMT From: Dave Scott To: POSTGRES@postgres.Berkeley.EDU Message-ID: <0097C2A8.F7F609A0.12809@vaxd.dct.ac.uk> Subject: arrays of arrays Resent-To: postgres-dist@postgres.Berkeley.EDU Resent-Date: Tue, 29 Mar 94 07:27:57 -0800 Resent-XMts: smtp Dear Postgresers, I seem to remember seeing this query before but have lost the relevant mail file. I'm attempting to create an application which is best modelled using arrays of arrays. I proceeded along the same lines as the example on p20 of the reference manual but when I attempt a query similar to: retrieve (stuff.a[2][2])\g I receive: syntax error at or near "[" I'm now attempting to create an array type from scratch and would be grateful for a brief explanation of how the "interesting stuff" is loaded into arrayp[0] .....arrayp[array_size] (example p21) Any help, pointers would be greatly appreciated, Thanks in advance, Dave.