Subject View limitations
Author PenWin
Hi again!

Are there any "official" limitations to what statement a VIEW can or can't
contain? I ask because in my Firebird 1.5 application I found a SELECT
statement which works perfectly as a standalone statement but can't be used
to create a VIEW:

SELECT *
FROM sometable
LEFT JOIN someprocedure(sometable.key) ON 1=1

I wonder if it is a known limitation of the engine or if it is a bug. Not
that it changes anything, as I can't upgrade to a newer version even if it
was a bug and got fixed, but I am curious.

Pepak