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
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 |
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. |