| From: | Pailloncy Jean-Gérard <jg(at)rilk(dot)com> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | DB2 feature |
| Date: | 2004-12-03 20:38:49 |
| Message-ID: | 56141B8E-456B-11D9-9C9F-000A95DE2550@rilk.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2004-12-03 21:02:46 | Re: DB2 feature |
| Previous Message | Cott Lang | 2004-12-03 16:55:55 | Re: Alternatives to Dell? |