<mmiranda@americatel.com.sv> schrieb im Newsbeitrag
news:76E0DAA32C39D711B6EC0002B364A6FA03F0A7FD@amsal01exc01.americatel.com.sv...
> > 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