Postgres Pro
Downloads
Home   >   mailing lists

Re: How to update rows from a cursor in PostgreSQL - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: How to update rows from a cursor in PostgreSQL
Date
Msg-id Pine.LNX.4.44.0302220303120.2067-100000@peter.localdomain
Whole thread Raw
In response to How to update rows from a cursor in PostgreSQL  (Ruben <ruben12@superguai.com>)
List pgsql-general
Tree view 
Ruben writes:

> Since "FOR UPDATE" cursors are not supported in PostgreSQL, can I update
> the current row of table t1?

There is no direct way, but some interfaces (e.g., ODBC, JDBC) emulate
updatable cursors in the client.

--
Peter Eisentraut   peter_e@gmx.net

pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: permissions
Next
From: Peter Eisentraut
Date:
Subject: Re: system catalog