Postgres Pro
Downloads
Home   >   mailing lists

Re: invalid reference to FROM-clause entry for table - Mailing list pgsql-sql

From David G. Johnston
Subject Re: invalid reference to FROM-clause entry for table
Date
Msg-id CAKFQuwbCDsije-GDqwr4T2XO8QWqw7A9xxX5jYVkmd2s5uRuug@mail.gmail.com
Whole thread Raw
In response to invalid reference to FROM-clause entry for table  (Sam Stearns <sam.stearns@dat.com>)
List pgsql-sql
Tree view
On Friday, October 4, 2024, Adw Spe <h.3stnc4kdbem6q_8p@outlook.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.

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: invalid reference to FROM-clause entry for table
Next
From: David Rowley
Date:
Subject: Re: Oracle ==> Postgres View