update
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.
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