Re: [HACKERS] PL/pgSQL EXECUTE '..' USING with unknown

[Andrew Dunstan]

On 08/05/2010 05:11 PM, Tom Lane wrote:
Heikki Linnakangas<heikki.linnakan...@enterprisedb.com>  writes:
There's a little problem with EXECUTE USING when the parameters are of
type unknown (going back to 8.4 where EXECUTE USING was introduced):
do $$
BEGIN
    EXECUTE 'SELECT to_date($1, $2)' USING '17-DEC-80', 'DD-MON-YY';
END;
$$;
ERROR:  failed to find conversion function from unknown to text
This example doesn't seem terribly compelling.  Why would you bother
using USING with constants?

                        

In a more complex example you might use $1 in more than one place in the 
query.

cheers

andrew

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers