Re: [HACKERS] Blowback from text conversion changes

2007-06-25 Thread Tom Lane
Gregory Stark <[EMAIL PROTECTED]> writes: > This seems odd. It's not deciding that it's ambiguous or coming from another > datatype for which no implicit cast exists. It knows perfectly well that it > wants to convert to text but fails? > postgres=# select 'a'||b from (select 'b' as b) as x; > ERR

Re: [HACKERS] Blowback from text conversion changes

2007-06-25 Thread D'Arcy J.M. Cain
On Mon, 25 Jun 2007 17:56:28 +0100 Gregory Stark <[EMAIL PROTECTED]> wrote: > > This seems odd. It's not deciding that it's ambiguous or coming from another > datatype for which no implicit cast exists. It knows perfectly well that it > wants to convert to text but fails? > > > postgres=# select

[HACKERS] Blowback from text conversion changes

2007-06-25 Thread Gregory Stark
This seems odd. It's not deciding that it's ambiguous or coming from another datatype for which no implicit cast exists. It knows perfectly well that it wants to convert to text but fails? postgres=# select 'a'||b from (select 'b' as b) as x; ERROR: failed to find conversion function from unkno