Re: Constraint exclusion issue
От
Mathieu De Zutter
Тема
Re: Constraint exclusion issue
Дата
Msg-id
d4468d971001161140n6f5e02d6he8ed979d13a0e521@mail.gmail.com
Ответ на
Re: Constraint exclusion issue (Scott Marlowe)
Список
Дерево обсуждения
Constraint exclusion issue Mathieu De Zutter <mathieu@dezutter.org>
Re: Constraint exclusion issue Jeff Davis <pgsql@j-davis.com>
Re: Constraint exclusion issue Mathieu De Zutter <mathieu@dezutter.org>
Re: Constraint exclusion issue Jeff Davis <pgsql@j-davis.com>
Re: Constraint exclusion issue Scott Marlowe <scott.marlowe@gmail.com>
Re: Constraint exclusion issue Mathieu De Zutter <mathieu@dezutter.org>
Re: Constraint exclusion issue Emanuel Calvo Franco <postgres.arg@gmail.com>
On Sat, Jan 16, 2010 at 7:26 PM, Scott Marlowe wrote:
> On Sat, Jan 16, 2010 at 11:02 AM, Mathieu De Zutter
> 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;
В списке pgsql-general по дате отправления
От: Raymond O'Donnell
Дата:
