>How would this differ from PERFORM? I think perform goes through the SQL by using SPI to execute the function, where as this statement will invoke a plpgsql function without going through the sql ( :-) ..in case i manage to add this statement )
thankz alot for your replies regards Sibtay On Tue, 15 Feb 2005 14:55:38 +1100, Neil Conway <[EMAIL PROTECTED]> wrote: > On Mon, 2005-02-14 at 17:02 +0500, Sibtay Abbas wrote: > > thank you for the detailed reply > > But what i wanted to know is that how can we actually get a function's > > oid from its > > name from within postgresql code itself > > You'll want to query the syscache. Note that due to function > overloading, there may be multiple functions with the same name, so > you'll need to figure out which one ought to be invoked by using the > number and types of the parameters. See FuncnameGetCandidates() in > namespace.c for an example. > > -Neil > > ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
