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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings