From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | Alexander Farber <alexander(dot)farber(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Implementing replace function |
Date: | 2010-10-31 09:12:38 |
Message-ID: | AANLkTik8riwzkH4fO_Ch6t+bjNjX6kGJ485XZ=gUNTr6@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
2010/10/31 Alexander Farber <alexander(dot)farber(at)gmail(dot)com>:
> Thanks Pavel, but I have an SQL procedure and not plpgsql?
it's not possible in sql. But plpgsql is same level like stored
procedures language from mysql.
>
> On Sun, Oct 31, 2010 at 9:34 AM, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> wrote:
>>> But how can I detect that the UPDATE has failed in my SQL procedure?
>>>
>>
>> see: http://www.postgresql.org/docs/8.4/interactive/plpgsql-control-structures.html
>> near to end of page
>
>>> create or replace function update_pref_users(id varchar,
>>> first_name varchar, last_name varchar, female boolean,
>>> avatar varchar, city varchar, last_ip inet) returns void as $$
>>>
>>> update pref_users set
>>> first_name = $2,
>>> last_name = $3,
>>> female = $4,
>>> avatar = $5,
>>> city = $6,
>>> last_ip = $7
>>> where id = $1;
>>>
>>> -- XXX how to detect failure here? XXX
>>>
>>> insert into pref_users(id, first_name, last_name,
>>> female, avatar, city, last_ip)
>>> values ($1, $2, $3, $4, $5, $6, $7);
>>> $$ language sql;
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
From | Date | Subject | |
---|---|---|---|
Next Message | Dmitriy Igrishin | 2010-10-31 09:37:38 | Re: Implementing replace function |
Previous Message | Alexander Farber | 2010-10-31 08:52:42 | Re: Implementing replace function |