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