From: | Jonathan Strong <jonathanrstrong(at)gmail(dot)com> |
---|---|
To: | Igor Korot <ikorot01(at)gmail(dot)com> |
Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: How to write such a query |
Date: | 2020-09-18 17:33:56 |
Message-ID: | CAK8Y=HV826Qw-1tPNOZwCnz+sNqYio8tvGDFW+4jPwL4NRDfKg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Are you looking to arbitrarily update the field in the fifth row, or can
the row that needs to be updated be isolated by some add'l attribute?
What's the use case?
- Jon
<https://www.linkedin.com/in/jonstrong/>
<https://www.jonathanrstrong.com>
*Jonathan Strong*
CIO / CTO / Consultant
*P:* 609-532-1715 *E:* jonathanrstrong(at)gmail(dot)com
*Quora Top Writer <https://www.quora.com/profile/Jonathan-R-Strong>*
On Fri, Sep 18, 2020 at 1:27 PM Igor Korot <ikorot01(at)gmail(dot)com> wrote:
> Hi,
> Consider following
>
> [code]
> CREATE TABLE X(id INTEGER PRIMARY KEY, field1 char(50), field2 int);
> CREATE TABLE Y(id INTEGER PRIMARY KEY, field1 char, field2 double(10, 2));
> SELECT X.field1, Y.field2 from X, Y WHERE X.id = Y.id;
> [/code]
>
> Assuming that the SELECT return 10 rows, I want to update X.field1
> in row 5.
>
> How do I write a WHERE clause in the
>
> [code]
> UPDATE X.field1 SET X.field1 = '<some_string>' WHERE....
> [/code]
>
> Thank you.
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Paul Förster | 2020-09-18 17:34:39 | Re: How to write such a query |
Previous Message | Igor Korot | 2020-09-18 17:29:14 | How to write such a query |