<mmiranda@xxxxxxxxxxxxxxxxx> schrieb im Newsbeitrag news:76E0DAA32C39D711B6EC0002B364A6FA03F0A7FD@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx > > 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, > Yes, oops. I have overlooked this. It wasn't listed where I expected it, sorry. Greetings, Andre ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
