DB2 feature
От | Pailloncy Jean-Gérard |
---|---|
Тема | DB2 feature |
Дата | |
Msg-id | 56141B8E-456B-11D9-9C9F-000A95DE2550@rilk.com обсуждение исходный текст |
Ответы |
Re: DB2 feature
|
Список | pgsql-performance |
Hi I see this article about DB2 http://www-106.ibm.com/developerworks/db2/library/techarticle/dm -0411rielau/?ca=dgr-lnxw06SQL-Speed The listing 2 example: 1 SELECT D_TAX, D_NEXT_O_ID 2 INTO :dist_tax , :next_o_id 3 FROM OLD TABLE ( UPDATE DISTRICT 4 SET D_NEXT_O_ID = D_NEXT_O_ID + 1 5 WHERE D_W_ID = :w_id 6 AND D_ID = :d_id 7 ) AS OT I am not a expert in Rule System. But I ad a look to http://www.postgresql.org/docs/7.4/static/rules-update.html And it seems possible in PostgreSQL to build non standard SQL query to do thing like listing 2. I would like to know from an "expert" of PostgreSQL if such query is really a new stuff to DB2 as the artcile states ? or if PostgreSQL has already the same type of power ? Cordialement, Jean-Gérard Pailloncy
В списке pgsql-performance по дате отправления: