On 08/05/2010 05:11 PM, Tom Lane wrote:
Heikki Linnakangas<[email protected]> 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 textThis 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
