Horton

Re: MySQL search query is not executing in Postgres DB

Peter Eisentraut <peter_e@gmx.net>

View thread
From: Peter Eisentraut <peter_e@gmx.net>
To: Robert Haas <robertmhaas@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Greg Stark <stark@mit.edu>, Bruce Momjian <bruce@momjian.us>, Andrew Dunstan <andrew@dunslane.net>, premanand <kottiprem@gmail.com>, pgsql-hackers@postgresql.org
Date: 2012-11-19T23:19:06Z
Lists: pgsql-hackers 
On Tue, 2012-11-06 at 10:57 -0500, Robert Haas wrote:
> But, with the attached patch:
> 
> rhaas=# create function xyz(smallint) returns smallint as $$select
> $1$$ language sql;
> CREATE FUNCTION
> rhaas=# select xyz(5);
>  xyz
> -----
>    5
> (1 row)
> 
> rhaas=# create table abc (a int);
> CREATE TABLE
> rhaas=# select lpad(a, 5, '0') from abc;
>  lpad
> ------
> (0 rows)

I continue to be of the opinion that allowing this second case to work
is not desirable.