Return-Path: pg_adm@postgres.berkeley.edu
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA00814; Thu, 21 May 92 12:35:28 -0700
Date: Thu, 21 May 92 12:35:28 -0700
Message-Id: <9205211935.AA00814@postgres.Berkeley.EDU>
From: chris@briet.berkeley.edu (Chris Plaunt)
Subject: access to user defined arrays
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu



Hi,

I can't get access to array elements other than the 0th and 1st.  Have
I missed something fundamental or does it simply not work as it
should?

define type foo ( input = array_in, output = array_out,
	internallength = 0, element = text )

create bar ( textarray = foo ) 

append bar ( textarray = "{"one","two","three","four"}")

retrieve ( bar.textarray[1] )
---------------
| textarray   |
---------------
| one         |
---------------

retrieve ( bar.textarray[2] )
Query sent to backend is "retrieve ( bar.textarray[2] ) "

This query never returns, and often kills the postmaster.  We're
runing Ultrix 4.2 on DECstation with Postgres 3.1.

Thanks, Chris (chris@briet.berkeley.edu)