> 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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx
