Lee Harr <missive@hotmail.com> said:
> >Unless your function parameter is an integer you must quote it... eq:
> >
> >select use_two_tables('tablename');
> >
>
> Hrm... That does not work either:
>
> # select use_two_tables('tablename');
> ERROR: function use_two_tables("unknown") does not exist
> HINT: No function matches the given name and argument types. You may need
> to add explicit type casts.
> # select use_two_tables('tablename'::text);
> ERROR: function use_two_tables(text) does not exist
> HINT: No function matches the given name and argument types. You may need
> to add explicit type casts.
Why not just use a text type in your definition?
CREATE or REPLACE FUNCTION use_two_tables(text) RETURNS text AS ...
You can always do a cast inside the procedure if you need to.
Best regards,
Jim Wilson
