Re: [GENERAL] MS-SQL to PostgreSQL

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

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

[GENERAL] MS-SQL to PostgreSQL

2005-01-07 Thread Craig Bryden
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 ***