Re: quote_literal(integer) does not exist

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Andreas 'ads' Scherbaum" <adsmail(at)wars-nicht(dot)de>
Cc: Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: quote_literal(integer) does not exist
Date: 2007-11-25 02:17:39
Message-ID: 7633.1195957059@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Andreas 'ads' Scherbaum" <adsmail(at)wars-nicht(dot)de> 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Gregory Stark 2007-11-25 02:35:58 Re: 8.3devel slower than 8.2 under read-only load
Previous Message Andreas 'ads' Scherbaum 2007-11-25 02:05:46 quote_literal(integer) does not exist