Re: show value of backslashes in string array argument

From: "Sabin Coanda" <sabin(dot)coanda(at)deuromedia(dot)ro>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: show value of backslashes in string array argument
Date: 2007-11-12 09:51:41
Message-ID: fh97n6$24vv$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I fond another collateral problem, because there are the different
convention to describe a varchar array item which contains backslashes, when
standard_conforming_strings = 'on'

For instance, to get a string composed by just one character backslash I can
use any of the two forms:

SELECT ARRAY[ '\' ]::varchar[];

or

SELECT '{\\}'::varchar[];

On the other hand, standard_conforming_strings = 'on' let me use varchar
items with '\' format. So the first format seems to be aware of
standard_conforming_strings = 'on', but the second is not.

My problem is that the java driver build arrays using the second format, but
the driver seems to be aware of standard_conforming_strings = 'on'. This
make inconsistence using the statement parameters, because to get the same
thing in the database I have to initialize a varchar parameter with a string
of one backslashes, but a varchar array item has to be initialized with a
string of two backslashes.

Sabin

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Achilleas Mantzios 2007-11-12 09:58:18 Re: show value of backslashes in string array argument
Previous Message Sabin Coanda 2007-11-12 09:15:48 show value of backslashes in string array argument