Re: DB2 feature

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Cc: Pailloncy Jean-Gérard <jg(at)rilk(dot)com>
Subject: Re: DB2 feature
Date: 2004-12-03 21:02:46
Message-ID: 200412031302.46772.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Jean-Gerard,

> 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

A lot of this is non-standard SQL, so I can't really tell what DB2 is doing
here. Can you explain it?

--
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco

In response to

  • DB2 feature at 2004-12-03 20:38:49 from Pailloncy Jean-Gérard

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Kiran Mukhyala 2004-12-03 22:12:26 Performance difference in similar queries
Previous Message Pailloncy Jean-Gérard 2004-12-03 20:38:49 DB2 feature