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

Le 16/11/2010 14:01, Dan Shoubridge a écrit :
>>>> Originally from SQL Server background, there is one feature that I
>>>> am missing and would save developers hours of time.
>>>>
>>>> In SQL Server I could copy sql code out of an application and
>>>> paste it into SSMS, declare & assign vars that exist in the sql
>>>> and run - great debugging scenario.
>>>> e.g. (please note I am rusty and syntax may be incorrect)
>>>>
>>>> declare @x as varchar(10)
>>>> set @x = 'abc'
>>>> select * from sometable where somefield = @x
>>>>
>>>> It would be amazing if simular functionality could be built into
>>>> in
>>>> pgadmin3 (NpgSQL uses : instead of @) where I can just drop my sql
>>>> (params & all) into the query window.
>>>>
>>>> I realise you can create pgscript, but it doesn't achieve the above...
>>>> Currently I have a peice of sql someone has written that has 3
>>>> unique varibles in it which are used around 7 times each...
>
>
>>> Le 16/11/2010 13:34, Guillaume Lelarge a écrit :
>
>>> And? I don't see why pgscript can't do that. The example you give is
> certainly doable with pgscript.
>
>>> Just for the record, the above script looks like this in pgscript:
>
>>> declare @x;
>>> set @x = 'abc';
>>> select * from sometable where somefield = '@x';
>
>>> And it works.
>
> 16/11/2010 13:00, Dan Shoubridge:
>
> (Apologies for messing up my reply, I've not used mailing lists before and
> they never get formatted correctly/
>
> Ok, I tried it - I think I must have missed of the quotes in my version, but
> that still defeats the point - It's easy to replace @ with :, but having to
> put quotes around all the vars makes it less efficient. Is there anything
> that can be done about this?
>

I don't think this is something we want to do. Problem is that variables
are not strictly typed, so there is nothing that could tell pgscript if
it should add simple quotes (simple quotes for text, but not for integer
for example).

> And I don't get any output in the 'Data Output tab' - this is the most
> important bit. - I can copy and paste the result that I can then run, after
> I've fiddled with the script a bit, but it isn't seamless. - Just a request
> as I think others would find it useful too?
>

Yeah, that's quite surprising. I would be useful but quite hard to do.

I think I'll add a ticket on this.

--
Guillaume
http://www.postgresql.fr
http://dalibo.com