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

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/