"returning" in postgresql request

Поиск
Список
Период
Сортировка
От GIROIRE, Nicolas (COFRAMI)
Тема "returning" in postgresql request
Дата
Msg-id 5C40CD1E4697424ABDE3AC57CF1B22C629CAB5@FR0-MAILMB20.res.airbus.corp
обсуждение исходный текст
Ответы Re: "returning" in postgresql request  (Richard Huxton <dev@archonet.com>)
Re: "returning" in postgresql request  (Tino Wildenhain <tino@wildenhain.de>)
Список pgsql-general
Hi,

    I try to deploy an Application with Oracle Database to a solution with postgresql.
    the Oracle system exists and we use a request which return an int in a variable nb by "returning nb_lock into nb"

    UPDATE xdb_ancestors_lock SET nb_lock=nb_lock+1 WHERE doc_id=? AND ele_id=? returning nb_lock INTO nb;

        I'd like to know if there is equivalent solution under postgresql or if i'm obliged to do a select before my
update.

        Best regards,

        Nico

This e-mail is intended only for the above addressee. It may contain
privileged information. If you are not the addressee you must not copy,
distribute, disclose or use any of the information in it. If you have
received it in error please delete it and immediately notify the sender.
Security Notice: all e-mail, sent to or from this address, may be
accessed by someone other than the recipient, for system management and
security reasons. This access is controlled under Regulation of
Investigatory Powers Act 2000, Lawful Business Practises.

В списке pgsql-general по дате отправления:

Предыдущее
От: Csaba Nagy
Дата:
Сообщение: Re: deadlocks in multiple-triggers environment
Следующее
От: Marco Colombo
Дата:
Сообщение: Re: vulnerability/SSL