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 MAA02565 for postgres-dist; Tue, 29 Mar 1994 12:02:19 -0800
Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199403292002.MAA02565@nobozo.CS.Berkeley.EDU>
Sender: owner-postman@postgres.Berkeley.EDU
X-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 MAA02556; Tue, 29 Mar 1994 12:02:18 -0800
Message-Id: <199403292002.MAA02556@nobozo.CS.Berkeley.EDU>
X-Authentication-Warning: nobozo.CS.Berkeley.EDU: Host localhost didn't use HELO protocol
From: aoki@postgres.Berkeley.EDU (Paul M. Aoki)
To: ejonge@tpd.tno.nl (Eric de Jonge)
Cc: postgres@postgres.Berkeley.EDU (post list)
Subject: Re: Arrays in Postgres 
Reply-To: aoki@postgres.Berkeley.EDU (Paul M. Aoki)
In-reply-to: Your message of Tue, 29 Mar 1994 11:14:49 +0200 (MET DST) 
	     <9403290914.AA27991@tpdbbs.local> 
Date: Tue, 29 Mar 94 12:02:18 -0800
X-Sender: aoki@postgres.Berkeley.EDU
Resent-To: postgres-dist@postgres.Berkeley.EDU
X-Mts: smtp
Resent-Date: Tue, 29 Mar 94 12:02:19 -0800
Resent-XMts: smtp

ejonge@tpd.tno.nl (Eric de Jonge) writes:
[postgres 4.1 arrays]
> Query sent to backend is "retrieve (sal_emp.all)"
> -----------------------------
> | name        | pay         |
> -----------------------------
> | billlll     | {}          |           <=================
> -----------------------------
> =====================================
> WHAT'S THIS (1 element = 0 element ?)
> =====================================

this bug was noted a while ago -- workaround: it is wise to quote 
all array elements in 4.1.

there was an even neater bug in 4.0.1..

> -----------------------------
> | name        | pay         |
> -----------------------------
> | billlll     | {1,2,3,4,5} |                <============
> -----------------------------
> ===============================
> AND THIS (> 4 elements)
> ===============================
> It isn't checked ???!!!

correct.  pretend that the 4.x (x<2) user manual doesn't ever use
the words "fixed length array".  they don't exist.

arrays have been totally reimplemented in 4.2.
--
  Paul M. Aoki  |  CS Div., Dept. of EECS, UCB  |  aoki@postgres.Berkeley.EDU
                |  Berkeley, CA 94720           |  ...!uunet!ucbvax!aoki