Re: Constraint exclusion issue

On Sat, Jan 16, 2010 at 7:26 PM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
> On Sat, Jan 16, 2010 at 11:02 AM, Mathieu De Zutter
> <mathieu@dezutter.org> 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;