Re: update

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: ruthvik(dot)yadagiri(at)gmail(dot)com, pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: Re: update
Date: 2022-10-03 11:19:22
Message-ID: 77c70669a451f528fc0b56b19478b4132eda8971.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

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

In response to

  • update at 2022-10-02 04:11:37 from PG Doc comments form

Browse pgsql-docs by date

  From Date Subject
Next Message PG Doc comments form 2022-10-03 13:50:26 More explicit documentation neede on "pgpass"
Previous Message Michael Paquier 2022-10-03 08:43:31 Re: Minor documentation fixes