Re: [GENERAL] MS-SQL to PostgreSQL

2005-01-07 Thread Alam Surya
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 --

Re: [GENERAL] MS-SQL to PostgreSQL

2005-01-07 Thread Michael Fuhr
On Fri, Jan 07, 2005 at 10:00:47PM +0200, Craig Bryden wrote: > I am not sure of the query part and in particular the assignment of the > values to the variables See SELECT INTO in the PL/pgSQL documentation. -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---(end of broad