| From: | Conxita Marín <comarin(at)telefonica(dot)net> |
|---|---|
| To: | <pgsql-novice(at)postgresql(dot)org> |
| Cc: | "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Subject: | Re: quoted_literal with numeric variable |
| Date: | 2003-01-20 07:59:26 |
| Message-ID: | 006b01c2c059$dac59780$0cd8a8c0@dims |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Thanks for your help.
For other novice users:
The complete solution is to convert the numeric variable in to text
variable with the text function.
EXECUTE ''INSERT INTO temp_tab VALUES(''
|| quote_literal(nombre) ||'',''
|| text(numero) ||'')'';
Conxita.
>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.
>When I execute the function, i get this message:
>
> ERROR: Function 'quote_literal(numeric)' does not exist
> Unable to identify a function that satisfies the given argument
types
> You may need to add explicit typecasts
| From | Date | Subject | |
|---|---|---|---|
| Next Message | joepie Platteau | 2003-01-20 11:11:53 | Database Performance problem |
| Previous Message | Conxita Marín | 2003-01-20 07:50:03 | Re: quoted_literal with numeric variable |