From: | Igor Korot <ikorot01(at)gmail(dot)com> |
---|---|
To: | Paul Förster <paul(dot)foerster(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:43:19 |
Message-ID: | CA+FnnTxzWqHBXk5tM8Bvze0hUNAvhg8qPa5PPV3UVs-BkfLQpg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi, Paul
On Fri, Sep 18, 2020 at 12:34 PM Paul Förster <paul(dot)foerster(at)gmail(dot)com> wrote:
>
> Hi Igor,
>
> > On 18. Sep, 2020, at 19:29, 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.
>
> update x set field1='<some string>' where id=5;
How do you know that the row #5 will have an X.id field 5?
Thank you.
>
> Cheers,
> Paul
From | Date | Subject | |
---|---|---|---|
Next Message | Igor Korot | 2020-09-18 17:46:53 | Re: How to write such a query |
Previous Message | Paul Förster | 2020-09-18 17:34:39 | Re: How to write such a query |