Sławek Cabaj schrieb am 11.12.2010 um 03:34 (-0800):

> Can anybody tell me what's wrong with this procedure ?

There is nothing wrong with it.

The SKIP 1 inside the procedure can be tricky, though.

> When I try to use it in select statement, for instance
>
> [...]
> WHERE SOME_FIELD IN (SELECT FIELD_1 FROM PROC)
>
> get an error: Procedure PROC is not selectable. It does not contain
> SUSPEND statement.

This works for me:

select * from ttt where a in (SELECT FIELD_1 FROM PROC);

Show us your real DDL and DML situation.

> (Firebird 2.1.3)

Firebird 2.5.0 here. It also works in 2.1.3.

--
Michael Ludwig