Subject Re: [firebird-support] Functions in PL/SQL
Author PenWin
>> Unfortunatelly, that won't do the trick: I need a function which gets
>> applied to every row in a certain view.

>You can get almost there with a selectable SP too:

> SELECT t.a, t.b, sp.whatever
> FROM table t
> LEFT JOIN storedproc(t.a, t.b) sp ON 1=1

That's only possible if I use the same query every time. Otherwise it is way
too slow to be practical.
Not to mention that as far as I know, Firebird does not allow to use
procedures from within views.

> With this approach(*), isn't it enough "switching" the placeholder
> function and the real one [whenever that's the case], simply declaring
> them with a unique name? You'd implement even the simple one as usual
> in the external module, and everything should run smooth...

I wanted to use this approach precisely because I have no control when (or
if) the UDF gets upgraded. If I could add a function to the UDF and have it
become effective immediately, I wouldn't bother with a simple function and
write the final one right away. Once again, it's not the function itself
which is a problem - it is making it available for my application.

Pepak