|
1 | 1 | <!-- |
2 | | -$PostgreSQL: pgsql/doc/src/sgml/ref/update.sgml,v 1.36 2006/01/22 20:34:11 tgl Exp $ |
| 2 | +$PostgreSQL: pgsql/doc/src/sgml/ref/update.sgml,v 1.37 2006/03/08 22:59:09 tgl Exp $ |
3 | 3 | PostgreSQL documentation |
4 | 4 | --> |
5 | 5 |
|
@@ -232,20 +232,6 @@ UPDATE employees SET sales_count = sales_count + 1 WHERE id = |
232 | 232 | </programlisting> |
233 | 233 | </para> |
234 | 234 |
|
235 | | - <para> |
236 | | - Now that all the papers are signed, update the most recently closed |
237 | | - deal of the travelling salesperson who closed the Rocket Powered |
238 | | - Skates deal with the Acme Corporation. |
239 | | -<programlisting> |
240 | | -UPDATE employees SET last_closed_deal = deal.id |
241 | | - FROM accounts JOIN deals ON (account.id = deal.account_id) |
242 | | - WHERE deal.employee_id = employees.id |
243 | | - AND deal.name = 'Rocket Powered Skates' |
244 | | - AND accounts.name = 'Acme Corporation' |
245 | | - ORDER BY deal.signed_date DESC LIMIT 1; |
246 | | -</programlisting> |
247 | | - </para> |
248 | | - |
249 | 235 | <para> |
250 | 236 | Attempt to insert a new stock item along with the quantity of stock. If |
251 | 237 | the item already exists, instead update the stock count of the existing |
|