Return-Path: postarch
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA17952; Tue, 18 Feb 92 12:04:55 -0800
Message-Id: <9202182004.AA17952@postgres.Berkeley.EDU>
From: postarch (Postgres Mailing Archive)
Subject: Re: Bug in Character Array Type
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu
Reply-To: mer@postgres.berkeley.edu
In-Reply-To: Your message of "Tue, 18 Feb 92 03:29:17 PST."
             <9202181129.AA11448@postgres.Berkeley.EDU>
Date: Tue, 18 Feb 92 12:04:42 PST

you write:
>
> When a tuple, which has a field value starting with the character '{', is
> appended to a relation, an error message "Unterminated array..." appears.
> This kind of value can't be appended in database.
>
> Is that right? Thanks.

You have to escape it:

	create bar ( a = char16, b = char[], d = text )
        \g
	append bar ( a = "\\{char16str",
                     b = "\\{ char[] array",
                     d = "\\{ text string")
        \g

Note that since I was typing these queries in to the monitor I needed
2 backslash characters.  If this had been in a libpq program I would
only have needed one.


Jeff Meredith
mer@postgres.berkeley.edu