Re: MySQL search query is not executing in Postgres DB - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: MySQL search query is not executing in Postgres DB
Date
Msg-id 503E5C20.1090302@gmx.net
Whole thread Raw
In response to Re: MySQL search query is not executing in Postgres DB  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: MySQL search query is not executing in Postgres DB
List pgsql-hackers
On 8/29/12 11:40 AM, Tom Lane wrote:
>>> regression=# select lpad(42,8);
>>> >>ERROR:  failed to find conversion function from integer to text
>>> >>I'm not sure why that's happening, either, but evidently some
>>> >>additional coercion laxity would required.
>> >This, however, is a trivial problem; make_fn_arguments just didn't get
>> >the memo that it might now need to look for assignment casts.  See
>> >attached.
> Meh.  I'm a bit worried about whether that might have unexpected
> consequences, too.

We are not seriously intending to make the above query work, are we?



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: splitting htup.h
Next
From: Alvaro Herrera
Date:
Subject: Re: splitting htup.h