Return-Path: postarch
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA00681; Tue, 31 Mar 92 10:52:53 -0800
Message-Id: <9203311852.AA00681@postgres.Berkeley.EDU>
From: postarch (Postgres Mailing Archive)
Subject: Re: arrays of strings
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu
In-Reply-To: Your message of "Tue, 31 Mar 92 08:23:58 PST."
             <9203311634.AA25351@postgres.Berkeley.EDU> 
Date: Tue, 31 Mar 92 10:52:44 PST

you write:

> >The best you can do without defining your own type is:
> >
> >	create foo ( a = text[20] )
> >
> >an array of text.  As you may already know text is a variable length type.
> >
> >
> >Jeff Meredith
> >mer@postgres.berkeley.edu
> 
> Unfortunately you can create this type, but for some reason we can't
> access any of the items in the array except the first item.  The
> retrieve query:
> 
>     retrieve (classname.textattr[2])
> 
>  is accepted by the backend but never returns.  If you come up with
> any other structure or can figure out why this query is giving us
> problems, please let us know.

Bug above.  You will have to define your own type for now. Sorry.


Jeff Meredith
mer@postgres.berkeley.edu