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 BAA28834 for postgres-dist; Tue, 29 Mar 1994 01:15:46 -0800 Resent-From: POSTGRES mailing list Resent-Message-Id: <199403290915.BAA28834@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 tpdusv.tpd.tno.nl (tpdusv.tpd.tno.nl [134.221.131.15]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id BAA28825 for ; Tue, 29 Mar 1994 01:15:40 -0800 Received: by tpdusv.tpd.tno.nl (5.65/DEC-Ultrix/4.3/GVA) id AA03791; Tue, 29 Mar 1994 11:14:55 +0200 Received: by tpdbbs.local (5.57/Ultrix3.0-C) id AA27991; Tue, 29 Mar 94 11:14:50 +0200 From: ejonge@tpd.tno.nl (Eric de Jonge) Message-Id: <9403290914.AA27991@tpdbbs.local> Subject: Arrays in Postgres To: postgres@postgres.Berkeley.EDU (post list) Date: Tue, 29 Mar 1994 11:14:49 +0200 (MET DST) X-Mailer: ELM [version 2.4 PL21] Content-Type: text Content-Length: 1200 Resent-To: postgres-dist@postgres.Berkeley.EDU Resent-Date: Tue, 29 Mar 94 01:15:46 -0800 Resent-XMts: smtp To all Postgres users, Postgres version 4.1 In the monitor: ============== * create sal_emp(name=char[], pay = int4[4])\g * append sal_emp(name="bill", pay="{1}")\g * retrieve (sal_emp.all)\g Query sent to backend is "retrieve (sal_emp.all)" ----------------------------- | name | pay | ----------------------------- | billlll | {} | <================= ----------------------------- ===================================== WHAT'S THIS (1 element = 0 element ?) ===================================== * append sal_emp(name="billlll", pay="{1,2,3,4,5}")\g * append sal_emp(name="billlll", pay="{1,2,3,4,5,6,7,8,9,10}")\g * retrieve (sal_emp.all)\g Query sent to backend is "retrieve (sal_emp.all)" ----------------------------- | name | pay | ----------------------------- | billlll | {} | ----------------------------- | billlll | {1,2,3,4,5} | <============ ----------------------------- | billlll | {1,2,3,4,5,6,7,8,9,10}| <============ ----------------------------- =============================== AND THIS (> 4 elements) =============================== It isn't checked ???!!! Eric de Jonge