Re: Built in display of contents of temporary tables when select has no destination

["Robert M. Bernabe" <rbernabe(at)sandmansystems(dot)com>]

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" <dpage(at)postgresql(dot)org>
To: "Robert M. Bernabe" <rbernabe(at)sandmansystems(dot)com>
Cc: "Postgres" <pgadmin-support(at)postgresql(dot)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/