Thread: Function quote_literal broken in CATALOG_VERSION_NO 200707251

Just FYI:

I took the latest snapshot CATALOG_VERSION_NO 200707251  and function 
quote_literal throws an error:

# select quote_literal(1);
2007-08-20 18:50:17 PDT ERROR:  function quote_literal(integer) does not 
exist at character 8
2007-08-20 18:50:17 PDT HINT:  No function matches the given name and 
argument types. You might need to add explicit type casts.
2007-08-20 18:50:17 PDT STATEMENT:  select quote_literal(1);
ERROR:  function quote_literal(integer) does not exist
LINE 1: select quote_literal(1);


I went back to an older snapshot CATALOG_VERSION_NO 200705211 and it 
works with the same SunStudio compiler and options:

postgres=# select quote_literal(1);quote_literal
---------------'1'
(1 row)


-Jignesh

"Jignesh K. Shah" <J.K.Shah@Sun.COM> writes:
> # select quote_literal(1);
> 2007-08-20 18:50:17 PDT ERROR:  function quote_literal(integer) does not 
> exist at character 8

quote_literal(integer) never existed in any previous release, either.

What you are seeing is a side effect of the removal of implicit casts to
text.  IMHO rejecting this query is a good thing.
        regards, tom lane