Re: Moving from Sybase to Postgres - Stored Procedures

> 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