Re: quoted_literal with numeric variable.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: cmarin(at)dims(dot)com
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: quoted_literal with numeric variable.
Date: 2003-01-16 17:49:25
Message-ID: 16653.1042739365@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

=?iso-8859-1?Q?Conxita_Mar=EDn?= <comarin(at)telefonica(dot)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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Rosta Farzan 2003-01-16 17:54:06 Re: reading command from file
Previous Message Tom Lane 2003-01-16 17:47:36 Re: VACUUM ANALYSE...