Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgres 12.4 inner join with where statement = 'string' returning error - Mailing list pgsql-admin

From David G. Johnston
Subject Re: Postgres 12.4 inner join with where statement = 'string' returning error
Date
Msg-id CAKFQuwYRcYBL_Wb84o8ZCMvcU0-O2etmH2MEDijqcYU5z=ZUQg@mail.gmail.com
Whole thread Raw
In response to Postgres 12.4 inner join with where statement = 'string' returning error  (VAE Ventures <vaeventures@outlook.com>)
List pgsql-admin
Tree view
On Sun, Jan 3, 2021 at 6:33 PM VAE Ventures <vaeventures@outlook.com> wrote:
SELECT * FROM table_1 INNER JOIN table_2 ON table_1.column = table_2.column WHERE table_1.column = ‘string’;
ERROR: column 'string' does not exist

The only way you will get "column 'string' does not exist" is if you wrote the word -string- surrounded by double-quotes so that it is interpreted as an object identifier instead of a literal value.  Assuming corresponding tables and columns exist, the query you show would not return that error.

David J.

pgsql-admin by date:

Previous
From: Ron
Date:
Subject: Re: Postgres 12.4 inner join with where statement = 'string' returning error
Next
From: Amine Tengilimoglu
Date:
Subject: pg_rewind restore_command issue in PG12