Subject Re: [firebird-support] Re: Stored Procedure as a Function?
Author Martijn Tonies
Dmitry,

> > Which - of course - brings us a new question... Would it be
> > possible to
> > create/sponsor functionality for an inline function created with
> > CREATE FUNCTION for Firebird 2.0? :-)
>
> Seriously speaking, they should appear in v2.0. I had them generally
working
> in my private tree some months ago, but since their implementation
requires
> an ODS change, it was deferred till the better times. The SQL standard
> declares them pretty clearly to follow, but they have a parsing conflict
> with UDFs (some kind of precedence must be chosen to solve it).

That's great to hear - this really is on my personal wishlist... :-)

btw, perhaps we should change "UDF" to become "External Function" -
User Defined Functions is also use for stored functions in several systems.
Perhaps a change of working could make things more clear.

As for the ODS change, I kind of expected that - and of course, the
UDF parsing thing makes sense too.

Time for a small discussion at fb-devel?


With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird & MS SQL Server.
Upscene Productions
http://www.upscene.com