Return-Path: postarch
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA19372; Mon, 11 May 92 11:49:27 -0700
Message-Id: <9205111849.AA19372@postgres.Berkeley.EDU>
From: postarch (Postgres Mailing Archive)
Subject: Re: Arrays
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu
In-Reply-To: Your message of "Wed, 06 May 92 01:33:49 PDT."
             <9205060833.AA13595@postgres.Berkeley.EDU> 
Date: Mon, 11 May 92 11:48:12 PDT

you write:

> Any attempt to replace a single item in an array failed.
> The class structure is:
> 
>         create atest2(array=int4[8])
> 
> After appending
> 
>         append atest2(array="{1,2,3,4,5,6,7,8}")
> 
> the replace command
> 
>         replace atest2(array[1]=3)
> 
> failed. The error message is
> 
>         Query sent to backend is "replace atest2(array[1]=3)"
>         WARN:May  6 10:02:10:parser: syntax error at or near "["
> 
> How do we get around this Problem?

This functionality isn't supported (although it should be).  There isn't
a workaround except to specify the entire constant.  I will add it to the
to-do priority queue.


Jeff Meredith
mer@postgres.berkeley.edu