MS-SQL to PostgreSQL
От | Craig Bryden |
---|---|
Тема | MS-SQL to PostgreSQL |
Дата | |
Msg-id | BAY12-F334DF13317BC1C781212F6B7940@phx.gbl обсуждение исходный текст |
Ответы |
Re: MS-SQL to PostgreSQL
|
Список | pgsql-general |
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 _________________________________________________________________ Research SA schools and varsities on MSN Search. http://search.msn.co.za
В списке pgsql-general по дате отправления: