Le 16/11/2010 23:26, Guillaume Lelarge a écrit : > 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. >
Ticket added. -- Guillaume http://www.postgresql.fr http://dalibo.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
