Return-Path: postarch
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA15468; Mon, 30 Mar 92 13:49:05 -0800
Message-Id: <9203302149.AA15468@postgres.Berkeley.EDU>
From: postarch (Postgres Mailing Archive)
Subject: Re: arrays of strings
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu
Reply-To: mer@postgres.berkeley.edu
In-Reply-To: Your message of "Tue, 24 Mar 92 20:44:59 PST."
             <9203250448.AA15791@postgres.Berkeley.EDU> 
Date: Mon, 30 Mar 92 13:48:54 PST

you write:

> We have a need to store arrays of strings, probably 50 characters in length, 
 +which means we
> can't use the char16[] type (or does it?).  Is there any way we can do this i
 +n
> postgres without having to define our own type?
> 
> Our C declaration for the type we are trying to store is:
> 
> char	term[20][50];

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