From: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
---|---|
To: | Andre Lopes <lopes80andre(at)gmail(dot)com> |
Cc: | postgresql Forums <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Complex transactions without using plPgSQL Functions. It is possible? |
Date: | 2012-03-06 19:37:40 |
Message-ID: | 4F566784.2010808@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 03/06/2012 11:30 AM, Andre Lopes wrote:
> Hi,
>
> I'm writing a web application that uses PostgreSQL and I need to do
> some operations where I read/write to 3 tables in the same
> transaction. To do this I need to store the values of variables and
> I'm not sure if it is possible to do this without using plPgSQL.
>
> [code]
> SELECT count(email) INTO vCONTA_HIST FROM am_newsletter_hist_alter
> WHERE email = pEMAIL AND id_website_recolha = pID_WEBSITE_RECOLHA;
>
> IF vCONTA_HIST = 0 THEN
> vNUM_ALTER := 1;
> ELSE
> SELECT MAX(num_alter) INTO vNUM_ALTER_ACT FROM am_newsletter_hist_alter
> WHERE email = pEMAIL AND id_website_recolha = pID_WEBSITE_RECOLHA LIMIT 1;
> vNUM_ALTER := vNUM_ALTER_ACT + 1;
> END IF;
> [/code]
>
> This is the plPgSQL code that I need to write in Python. It is
> possible to do this without using PlPgSQL?
Sure:
http://www.postgresql.org/docs/9.0/interactive/plpython-database.html
>
> Best Regards,
>
--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Thom Brown | 2012-03-06 19:43:24 | Re: Unhelpful initdb error message |
Previous Message | Andre Lopes | 2012-03-06 19:30:24 | Complex transactions without using plPgSQL Functions. It is possible? |