| From: | Mathieu De Zutter <mathieu(at)dezutter(dot)org> |
|---|---|
| To: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Constraint exclusion issue |
| Date: | 2010-01-16 19:40:43 |
| Message-ID: | d4468d971001161140n6f5e02d6he8ed979d13a0e521@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Sat, Jan 16, 2010 at 7:26 PM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> wrote:
> On Sat, Jan 16, 2010 at 11:02 AM, Mathieu De Zutter
> <mathieu(at)dezutter(dot)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;
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ivan Sergio Borgonovo | 2010-01-16 20:57:03 | Re: OR tsquery |
| Previous Message | Raymond O'Donnell | 2010-01-16 18:59:57 | Re: SELECT is causing a runtime error when used in stored functions: State=42601, Err=7, Msg=ERROR: query has no destination for result data; |