From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Andy Colson <andy(at)squeakycode(dot)net> |
Cc: | David Johnston <polobo(at)yahoo(dot)com>, "'PostgreSQL'" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: string = any() |
Date: | 2012-01-10 16:42:09 |
Message-ID: | 24939.1326213729@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Andy Colson <andy(at)squeakycode(dot)net> writes:
> My confusion was from:
> clayia=# select '{''joe'', ''bob'' }';
> ?column?
> -----------------
> {'joe', 'bob' }
> (1 row)
> It does return an array of string, or so it looks.
Yeah, it's not obvious that those quote marks are really data
characters. I wonder whether we could get away with tweaking array_out
to consider single-quote marks as being grounds for quoting an array
element. Then you would have seen a result like
?column?
---------------------
{"'joe'", "'bob'"}
which might at least have given you an inkling of what was happening.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2012-01-10 17:38:00 | Re: How do you change the size of the WAL files? |
Previous Message | Andy Colson | 2012-01-10 16:33:27 | Re: string = any() |