From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Colin DuPlantis <colind(at)sun(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Arrays and backslashes |
Date: | 2006-08-19 14:02:28 |
Message-ID: | 17476.1155996148@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Colin DuPlantis <colind(at)sun(dot)com> writes:
> I am having trouble inserting a value into the array column that
> contains a single '\' (no quotes) character. The following examples are
> my attempts to produce a value of 'x\y' (no quotes) in both the regular
> text and the text array columns in the test table:
> insert into test values ( 'x\\y', array['x\\y']);
> c1 | c2
> -----+----------
> x\y | {"x\\y"}
> (1 row)
The above is perfectly correct: the actual value in c2[1] is 'x\y'.
Read the docs about array I/O formatting:
http://www.postgresql.org/docs/8.1/static/arrays.html#AEN5716
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Fuhr | 2006-08-19 14:34:32 | Re: Connection string |
Previous Message | Michael Meskes | 2006-08-19 13:36:42 | Re: Connection string |