Re: Moving from Sybase to Postgres - Stored Procedures

<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