Hello 2009/9/7 Tomasz Karlik <tomasz.kar...@ultimo.pl>: > > >>>> Alvaro Herrera <alvhe...@commandprompt.com> 9/4/2009 7:23 PM >>> > 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; >
it some strange. What version do you use? on 5.4 postgres=# explain select * from pg_class where relname='aaa'; QUERY PLAN -------------------------------------------------------------------------------- ------------- Index Scan using pg_class_relname_nsp_index on pg_class (cost=0.00..8.27 rows= 1 width=185) Index Cond: (relname = 'aaa'::name) (2 rows) the casting is implicit. regards Pavel Stehule > If you're looking for a speedy answer, try a SQL function, not plpgsql. > > > The same issue when using SQL function... However other casting (for example > int4->int8) works properly. > -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs