Message-ID: <77c70669a451f528fc0b56b19478b4132eda8971.camel@cybertec.at>
Subject: Re: update
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: ruthvik.yadagiri@gmail.com, pgsql-docs@lists.postgresql.org
Date: Mon, 03 Oct 2022 13:19:22 +0200
In-Reply-To: <166468389726.659.15572879155612715570@wrigleys.postgresql.org>
References: <166468389726.659.15572879155612715570@wrigleys.postgresql.org>
Content-Type: text/plain; charset="UTF-8"
User-Agent: Evolution 3.42.4 (3.42.4-2.fc35) 
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Archived-At: 
 <https://www.postgresql.org/message-id/77c70669a451f528fc0b56b19478b4132eda8971.camel%40cybertec.at>
Precedence: bulk

On Sun, 2022-10-02 at 04:11 +0000, PG Doc comments form wrote:
> The following documentation comment has been logged on the website:
> 
> Page: https://www.postgresql.org/docs/14/tutorial-update.html
> Description:
> 
> the syntax used for update is a bit incorrect
> if the syntax used as it is mentioned in the site then the update will be
> done only to the last row in the table because of the use of symbol < after
> where.
> it should be fixed by using the symbol = after where.

First, the symbol used is >.

Then, the text says "... after November 28. You can correct the data as follows:"
Now "date > '1994-11-28'" is quite appropriate for dates after November 28.
There must be a misunderstanding on your side.

Yours,
Laurenz Albe