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.
----- Original Message -----
From: "Dave Page" <[EMAIL PROTECTED]>
To: "Robert M. Bernabe" <[EMAIL PROTECTED]>
Cc: "Postgres" <pgadmin-support@postgresql.org>
Sent: Monday, December 10, 2007 5:25 PM
Subject: Re: [pgadmin-support] Built in display of contents of temporary
tables when select has no destination
Robert M. Bernabe wrote:
Hi,
Not sure if this is the proper forum but I'd like to post a request
of sorts. The PG Admin III SQL Editor and Debugger are great but I've
noticed that when a select statement has no destination, the software
issues an error.
What do you mean 'has no destination'? Can you provide an example?
Regards, Dave
I'm protected by SpamBrave
http://www.spambrave.com/
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
