help in debugging querries 1

[xenology]

How do you display messages while a query is running? For example, how would you do the "print" statement below?

select username from users where active=true;
if found then
print 'inside the if statement';
end if;

This is useful when debugging functions and you have multiple conditional statements and trying to determine where your code is not returning expected results.
**Note: using PGAdminIII or Navicat to write/test functions/queries.
thanks!

 

[ceco]

if you are talking about plpgsql functions use

raise notice

http://www.postgresql.org/docs/8.2/interactive/plpgsql-errors-and-messages.html