Postgres Pro
Downloads
Home   >   mailing lists

Re: Complex transactions without using plPgSQL Functions. It is possible? - Mailing list pgsql-general

From Sergey Konoplev
Subject Re: Complex transactions without using plPgSQL Functions. It is possible?
Date
Msg-id CAL_0b1vEHQ1TNjCQ02iov5ctBpk3v9x8KSWJsemTUaxo2fC3GA@mail.gmail.com
Whole thread Raw
In response to Complex transactions without using plPgSQL Functions. It is possible?  (Andre Lopes <lopes80andre@gmail.com>)
Responses Re: Complex transactions without using plPgSQL Functions. It is possible?
List pgsql-general
Tree view 
On Tue, Mar 6, 2012 at 11:30 PM, Andre Lopes <lopes80andre@gmail.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.ru@gmail.com Skype: gray-hemp

pgsql-general by date:

Previous
From:
Date:
Subject: ERROR: could not find tuple for trigger 37463634
Next
From:
Date:
Subject: Re: ERROR: could not find tuple for trigger 37463634