Re: Moving from Sybase to Postgres - Stored Procedures
От | mmiranda@americatel.com.sv |
---|---|
Тема | Re: Moving from Sybase to Postgres - Stored Procedures |
Дата | |
Msg-id | 76E0DAA32C39D711B6EC0002B364A6FA03F0A7FD@amsal01exc01.americatel.com.sv обсуждение исходный текст |
Ответ на | Moving from Sybase to Postgres - Stored Procedures ("Andre Schnoor" <andre.schnoor@web.de>) |
Список | pgsql-general |
> CREATE PROCEDURE do_something > @song_id int, > @user_id int, > @method int, > @length int = 0, > @date_exact datetime, > @default_country int = null > AS > -- temporary variables > DECLARE > @artist int, > @sample int, > @date varchar(32), > @country int > BEGIN > -- assign temporary variables > select @date = convert(varchar(32),@date_exact,101) > select @artist = user_id, @sample = is_sample from sto_song where > song_id = @song_id -- perform conditional code > if (@sample = 1) begin > begin transaction > ... do something ... > commit transaction > end else begin > ... do something else ... > end > -- return results > select > result1 = ... some expression ..., > result2 = ... another expression ... > END > > I could not yet translate this to PgSQL, as I can't find any control > structures, variable declaractions, etc. > Am I missing something important? > Absolutely, that is a perfectly normal SP, i use those constructors everyday, maybe you dont have searched in the docs?. Perl?, i dont think so, PL/pgSQL is all what you need, http://www.postgresql.org/docs/7.3/interactive/programmer-pl.html --- Miguel > Greetings, > Andre
В списке pgsql-general по дате отправления: