"Andreas 'ads' Scherbaum" <[EMAIL PROTECTED]> writes:
> we have some plpgsql functions which use quote_literal() regardless of
> the data type. With Beta 3 this does not work anymore[1].
If you're unwilling to fix your application, you can hack around that
for yourself.
regression=# select quote_literal(42);
ERROR: function quote_literal(integer) does not exist
LINE 1: select quote_literal(42);
^
HINT: No function matches the given name and argument types. You might need to
add explicit type casts.
regression=# create function quote_literal(anyelement) returns text as $$
regression$# select pg_catalog.quote_literal($1 :: pg_catalog.text)
regression$# $$ language sql;
CREATE FUNCTION
regression=# select quote_literal(42);
quote_literal
---------------
'42'
(1 row)
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
