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

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
     subscribe-nomail command to [EMAIL PROTECTED] so that your
     message can get through to the mailing list cleanly

Reply via email to