Robert M. Bernabe wrote:
> Hi Dave,
> Within a function just type select * from table; ...call the function
> and the SQL editor will give an error saying that the select statement
> has no destination...which is true...:) but often very complex stored
> functions have temporary tables within and the only way to display the
> contents while debugging is to use a loop with raise info calls. It
> would be great if the debugger automatically streams all select
> statements to a output and formatted already for viewing.
Oh, I see what you mean. Unfortunately thats not possible with the way
the server is currently designed - you would need to use RAISE as you
mention I'm afraid.
Regards, Dave
