Horton

Re: quote_literal(integer) does not exist

Pavel Stehule <pavel.stehule@gmail.com>

View thread View on postgr.es
From: "Pavel Stehule" <pavel.stehule@gmail.com>
To: "Brendan Jurd" <direvus@gmail.com>
Cc: "Andreas 'ads' Scherbaum" <adsmail@wars-nicht.de>, pgsql-hackers@postgresql.org, "Bruce Momjian" <bruce@momjian.us>, "Tom Lane" <tgl@sss.pgh.pa.us>
Date: 2007-11-25T14:02:31Z
Lists: pgsql-hackers 
Hello

>
> Having quote_literal take its argument as text was fine whilst we were
> automatically casting arguments, but in 8.3 it seems that
> quote_literal(anyelement) makes a lot more sense than
> quote_literal(text).
>
> So, I wonder why we don't just adapt the internal function to take
> anyelement?  It would save a lot of apps from being broken by the move
> to 8.3, and make the function more convenient.
>

It's good idea. I'll look on it.

It needs change of pgproc :(

Pavel