From: | mmiranda(at)americatel(dot)com(dot)sv |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Moving from Sybase to Postgres - Stored Procedures |
Date: | 2005-01-28 22:12:34 |
Message-ID: | 76E0DAA32C39D711B6EC0002B364A6FA03F0A7FD@amsal01exc01.americatel.com.sv |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> 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
From | Date | Subject | |
---|---|---|---|
Next Message | John Sidney-Woollett | 2005-01-28 22:18:42 | Re: Moving from Sybase to Postgres - Stored Procedures |
Previous Message | Mark Wong | 2005-01-28 22:06:43 | OLS BOF for linux & postgresql |