On 07/04/2013 10:14 AM, giozh wrote:
something gone wrong the same...
REATE OR REPLACE FUNCTION check_if_if_exist(id integer, table_name
character, table_column character)
RETURNS boolean AS
$BODY$
DECLARE res BOOLEAN;
BEGIN
EXECUTE 'SELECT EXISTS(SELECT * FROM'||table_name||
'WHERE'||table_column||'='||$1||')' INTO res USING id;
RETURN res;
END;
select check_if_exist(10, 'prova', 'identificatore');
RROR: function check_if_exist(integer, unknown, unknown) does not exist
LINE 1: select check_if_exist(10, 'prova', 'identificatore');
^
HINT: No function matches the given name and argument types. You might need
to add explicit type casts.
Got hung up on the function definition and skipped over the error
message. Looks like Postgres is not seeing 'prova' and 'identificatore'
as text.
What happens if you do?:
select check_if_exist(10, 'prova'::text, 'identificatore'::text);
--
Adrian Klaver
adrian.klaver@xxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
