tkar...@ultimo.pl wrote: > Without casting function executes much slower: > > CREATE OR REPLACE FUNCTION table_exists(tblname text) RETURNS boolean AS ' > DECLARE > exists boolean; > BEGIN > SELECT 1 INTO exists FROM pg_class WHERE relname = name($1); > RETURN exists; > END; > ' LANGUAGE 'plpgsql' IMMUTABLE;
If you're looking for a speedy answer, try a SQL function, not plpgsql. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs