Re: Postgres 12.4 inner join with where statement = 'string' returning error

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Postgres 12.4 inner join with where statement = 'string' returning error
Дата
Msg-id CAKFQuwYRcYBL_Wb84o8ZCMvcU0-O2etmH2MEDijqcYU5z=ZUQg@mail.gmail.com
обсуждение исходный текст
Ответ на Postgres 12.4 inner join with where statement = 'string' returning error  (VAE Ventures <vaeventures@outlook.com>)
Список pgsql-admin
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Ron
Дата:
Сообщение: Re: Postgres 12.4 inner join with where statement = 'string' returning error
Следующее
От: Amine Tengilimoglu
Дата:
Сообщение: pg_rewind restore_command issue in PG12