Re: Many Pl/PgSQL parameters -> AllocSetAlloc(128)?

From: "Ian Harding" <ianh(at)tpchd(dot)org>
To: <mail(at)joeconway(dot)com>, <reuven(at)lerner(dot)co(dot)il>
Cc: <pgsql-general(at)postgresql(dot)org>, <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Many Pl/PgSQL parameters -> AllocSetAlloc(128)?
Date: 2003-06-24 13:55:35
Message-ID: sef7f63a.074@mail.tpchd.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

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(at)tpchd(dot)org
Phone: (253) 798-3549
Pager: (253) 754-0002

>>> "Reuven M. Lerner" <reuven(at)lerner(dot)co(dot)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

Browse pgsql-general by date

  From Date Subject
Next Message Cornelia Boenigk 2003-06-24 13:58:47 Re: [GENERAL] interesting PHP/MySQL thread
Previous Message Arjen van der Meijden 2003-06-24 13:53:40 Re: [GENERAL] Documentation quality WAS: interesting

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2003-06-24 13:56:34 Re: dblink_ora - a first shot on Oracle ...
Previous Message Bruce Momjian 2003-06-24 13:54:32 Re: 2Q implementaion for PostgreSQL buffer replacement.