Re: How do I upsert depending on a second table?

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
adrian.klaver@aklaver.com