update

Started by PG Bug reporting formover 3 years ago2 messagesdocs
Jump to latest
#1PG Bug reporting form
noreply@postgresql.org

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.

#2Laurenz Albe
laurenz.albe@cybertec.at
In reply to: PG Bug reporting form (#1)
Re: update

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