Request a Demo
Home   >   mailing lists

Re: How do I upsert depending on a second table? - Mailing list pgsql-general

From Adrian Klaver
Subject Re: How do I upsert depending on a second table?
Date
Msg-id a31acf07-0ff7-4be3-8235-e4151edc4208@aklaver.com
Whole thread Raw
In response to Re: How do I upsert depending on a second table?  (Samuel Marks <samuelmarks@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: How do I upsert depending on a second table?
Next
From: Samuel Marks
Date:
Subject: Re: How do I upsert depending on a second table?