I believe Dmitry has this already working
in his private tree. The trick is to write
a selectable procedure and to have DSQL
automatically wrap it in singleton select.

Alternatively, Fyracle has support for
PL/SQL functions

Paul

--- In Firebird-Architect@yahoogroups.com, "Fabricio Araujo"
<fabricioa@i...> wrote:

> Appear that some people would like
> to implement some simple functions in
> FB PL/SQL. There are some (easy/
> not sloppy) way to implement something
> like a CREATE FUNCTION statement
> (will return a scalar type - varchar,
> integers, floats, etc only one value).
> No allowed to return resultsets.