How come you didn't get a "No such function with those arguments" error that I always get when I do that?

planning=# create function oops (integer) returns int language pltcl as '
planning'# elog NOTICE "blah"
planning'# ';
CREATE FUNCTION
planning=# select oops (cast('duh' as varchar));
ERROR:  Function oops(character varying) does not exist
        Unable to identify a function that satisfies the given argument types
        You may need to add explicit typecasts


Ian Harding
Programmer/Analyst II
Tacoma-Pierce County Health Department
iharding@tpchd.org
Phone: (253) 798-3549
Pager: (253) 754-0002


>>> "Reuven M. Lerner" <reuven@lerner.co.il> 06/23/03 11:56PM >>>
Excellent -- thanks so much for your help.  I just tried the function
with the right arguments, and it worked just fine.

Yet more proof of named parameters being a good thing...

Reuven

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings


Tue, 24 Jun 2003 06:55:35 -0700
"Ian Harding" <ianh@tpchd.org>
Re: Many Pl/PgSQL parameters -> AllocSetAlloc(128)?