>>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'
>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.
>>>&g
t; > 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 = &
> > Le 16/11/2010 13:14, 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 applicat
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
