From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Ken Tanzer <ken(dot)tanzer(at)gmail(dot)com> |
Cc: | PG-General Mailing List <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: What does this error message mean? |
Date: | 2013-11-18 03:59:36 |
Message-ID: | 14635.1384747176@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Ken Tanzer <ken(dot)tanzer(at)gmail(dot)com> writes:
> But thinking about it some more, the function runs one of 5 possible
> queries. 4 of them select NULL as comment (no cast), while the fifth (and
> the one that caused this error) selects 'a string'.
Ah. Fixing that so all the variants produce the same (explicit) type
should take care of this.
> I assume this will go away if I change my lazy query and cast my NULLs, but
> still wonder if this is something that should be expected to fail?
Ideally it wouldn't, but it's not clear what it'd cost to fix it.
If we just silently replanned when the query output types changed,
then this type of situation would work but would carry a large hidden
performance penalty. That's not too appetizing either.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Tony Theodore | 2013-11-18 04:07:41 | Re: Composite types or composite keys? |
Previous Message | David Johnston | 2013-11-18 03:52:31 | Re: Sum 2 tables based on key from other table |