On Sat, Jan 16, 2010 at 7:26 PM, Scott Marlowe <scott.marlowe@xxxxxxxxx> wrote:
> On Sat, Jan 16, 2010 at 11:02 AM, Mathieu De Zutter
> <mathieu@xxxxxxxxxxxx> wrote:
>> shs-dev=# explain select * from parent where (c,n) = '("b",0)';
>> ERROR: input of anonymous composite types is not implemented
>
> Shouldn't that be 'b' not "b" ?
It is special syntax to avoid escapes:
shs-dev=# select '("b",0)'::y;
y
-------
(b,0)
shs-dev=# select ('("b,",0)'::y).c;
ERROR: value too long for type character(1)
LINE 1: select ('("b,",0)'::y).c;
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
