From 90f249489d932dc00a8380d2f56c6df7f1118f05 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Wed, 8 Mar 2006 22:59:17 +0000 Subject: [PATCH] Remove somebody's flight of fancy about an UPDATE with ORDER BY and LIMIT. --- doc/src/sgml/ref/update.sgml | 14 -------------- 1 file changed, 14 deletions(-) diff --git a/doc/src/sgml/ref/update.sgml b/doc/src/sgml/ref/update.sgml index 72f2f2ecea..486eb5861a 100644 --- a/doc/src/sgml/ref/update.sgml +++ b/doc/src/sgml/ref/update.sgml @@ -216,20 +216,6 @@ UPDATE employees SET sales_count = sales_count + 1 WHERE id = - - Now that all the papers are signed, update the most recently closed - deal of the travelling salesperson who closed the Rocket Powered - Skates deal with the Acme Corporation. - -UPDATE employees SET last_closed_deal = deal.id - FROM accounts JOIN deals ON (account.id = deal.account_id) - WHERE deal.employee_id = employees.id - AND deal.name = 'Rocket Powered Skates' - AND accounts.name = 'Acme Corporation' - ORDER BY deal.signed_date DESC LIMIT 1; - - - Attempt to insert a new stock item along with the quantity of stock. If the item already exists, instead update the stock count of the existing -- 2.39.5