Re: Feature Request for Debugging SQL in PGAdmin3 when SQL contains variables

From: "Paragon Corporation" <lr(at)pcorp(dot)us>
To: <pgadmin-support(at)postgresql(dot)org>
Subject: Re: Feature Request for Debugging SQL in PGAdmin3 when SQL contains variables
Date: 2010-11-17 09:51:21
Message-ID: A612506904F4410B9E252786B1DBD065@J
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support


Dan,
> Ok, I understand and it's a shame the vars aren't strong typed. It's
little things like that that make me want SQL Server back. It doesn't seem
like a big thing to some people, but for a lot of developers the amount of
> work added by this when debugging sql adds up over time.

I know it's a new invention in PostgreSQL 9.0 so might not be an option for
you, but wouldn't the new

DO command do what you are looking for?

http://wiki.postgresql.org/index.php?title=PostgreSQL_9.0#Anonymous_Function
s_.28aka_Anonymous_Blocks.29

Leo

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Dan Shoubridge 2010-11-17 11:22:29 Re: Feature Request for Debugging SQL in PGAdmin3 when SQL contains variables
Previous Message Dave Page 2010-11-17 09:49:56 Re: Feature Request for Debugging SQL in PGAdmin3 when SQL contains variables