Hi Craig.... try with this....
Declare v_maxval integer; v_minval integer; Begin Select max(value),min(value) into v_maxval,v_minval from ABC; ............ ............ ............ end; or see SELECT INTO from postgresql documentation regards, Alam Surya ----- Original Message ----- From: "Craig Bryden" <[EMAIL PROTECTED]> Subject: [GENERAL] MS-SQL to PostgreSQL > Hi > > Below is a snippet of MS-SQL code. Please can someone translate this to > plpgsql for me. > > ************************************************************** > DECLARE @MaxVal int, @MinVal int > > SELECT @MaxVal = MAX(Value), @MinVal = MIN(Value) > FROM ABC > ************************************************************** > > The variables would then be used for purther processing. > I know that the variables would be declared like > > ******************************************* > DECLARE > MaxVal int; > MinVal int; > BEGIN > ??? > END; > ******************************************* > > I am not sure of the query part and in particular the assignment of the > values to the variables > > Thank you > Craig ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
