public inbox for [email protected]
help / color / mirror / Atom feedFrom: Adrian Klaver <[email protected]>
To: Samuel Marks <[email protected]>
Cc: [email protected]
Subject: Re: How do I upsert depending on a second table?
Date: Tue, 23 Sep 2025 14:00:50 -0700
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAMfPbcZzUYZ6yoN-TnpNQZ4PzhFCCiTdchbtwz83+B0Byyk-fw@mail.gmail.com>
References: <CAMfPbcbjTE6=yVJjAyiNU=kM24e-0oLo8S1ZZ7dJZy3UKq+b3g@mail.gmail.com>
<[email protected]>
<CAMfPbcZzUYZ6yoN-TnpNQZ4PzhFCCiTdchbtwz83+B0Byyk-fw@mail.gmail.com>
On 9/23/25 13:56, Samuel Marks wrote:
> the AS syntax can alternatively be used for aliases
> https://www.postgresql.org/docs/current/sql-select.html
>
> `SELECT actual_tablename table0 WHERE table0.column00 = 1`
Ok, I missed the:
... FROM org org_tbl ...
>
> (I used a space)
Yeah, I use tbl_name AS alias_name to help these old eyes catch this
sort of thing in my queries.
--
Adrian Klaver
[email protected]
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: How do I upsert depending on a second table?
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox