Re: Complex transactions without using plPgSQL Functions. It is possible?

From: Sergey Konoplev <gray(dot)ru(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-07 10:19:40
Message-ID: CAL_0b1vEHQ1TNjCQ02iov5ctBpk3v9x8KSWJsemTUaxo2fC3GA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Mar 6, 2012 at 11:30 PM, Andre Lopes <lopes80andre(at)gmail(dot)com> wrote:
> This is the plPgSQL code that I need to write in Python. It is
> possible to do this without using PlPgSQL?

Do you want it to be done using pure SQL or you do not want to wrap it
into a stored function?

In the second case look at the DO command
http://www.postgresql.org/docs/9.1/static/sql-do.html

--
Sergey Konoplev

Blog: http://gray-hemp.blogspot.com
LinkedIn: http://ru.linkedin.com/in/grayhemp
JID/GTalk: gray(dot)ru(at)gmail(dot)com Skype: gray-hemp

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message mdione.ext 2012-03-07 10:27:46 Re: ERROR: could not find tuple for trigger 37463634
Previous Message mdione.ext 2012-03-07 10:18:47 ERROR: could not find tuple for trigger 37463634