Subject | Re: [firebird-support] Functions in PL/SQL |
---|---|
Author | PenWin |
Post date | 2008-02-14T13:03:10Z |
>> Unfortunatelly, that won't do the trick: I need a function which getsThat's only possible if I use the same query every time. Otherwise it is way
>> 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
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 placeholderI wanted to use this approach precisely because I have no control when (or
> 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...
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