Re: quoted_literal with numeric variable. - Mailing list pgsql-novice

=?iso-8859-1?Q?Conxita_Mar=EDn?= <comarin@telefonica.net> writes:
> How to construct an 'EXECUTE' sentence into a function using numeric
> variables?
> To insert the variable in the string to execute, i use
> 'quote_literal(numero)' where numero is a numeric variable.

Don't bother with quote_literal.  You only need that for string values
that might contain quotes or backslashes.  A numeric variable won't have
either.

            regards, tom lane