Re: invalid reference to FROM-clause entry for table

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Adw Spe <h(dot)3stnc4kdbem6q_8p(at)outlook(dot)com>
Cc: Sam Stearns <sam(dot)stearns(at)dat(dot)com>, "pgsql-sql(at)lists(dot)postgresql(dot)org" <pgsql-sql(at)lists(dot)postgresql(dot)org>, Peter Garza <peter(dot)garza(at)dat(dot)com>, Henry Ashu <henry(dot)ashu(at)dat(dot)com>
Subject: Re: invalid reference to FROM-clause entry for table
Date: 2024-10-05 02:35:02
Message-ID: CAKFQuwbCDsije-GDqwr4T2XO8QWqw7A9xxX5jYVkmd2s5uRuug@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Friday, October 4, 2024, Adw Spe <h(dot)3stnc4kdbem6q_8p(at)outlook(dot)com> wrote:

> Maybe I’m wrong, but I think every subquery must at least have a
> SELECT-FROM pair.
>

You are indeed wrong - at least for PostgreSQL. No query requires a from
clause in PostgreSQL.

David J.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Sam Stearns 2024-10-15 21:30:55 Oracle ==> Postgres View
Previous Message Sam Stearns 2024-10-04 15:12:49 Re: invalid reference to FROM-clause entry for table