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

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

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

VAE Ventures
I am running a db on postgres12.4

I have been trying to run a query that looks like this:

SELECT * FROM table_1 INNER JOIN table_2 ON table_1.column = table_2.column WHERE table_1.column = ‘string’;

I am being returned:

ERROR: column 'string' does not exist

The following queries work fine:

SELECT * FROM table_1 INNER JOIN table_2 ON table_1.column = table_2.column WHERE table_1.column = int;

SELECT * FROM table_1 WHERE column = ‘string’;

I read several posts about this error, which seems very common and is usually solved by switching up quotation variations around the table name, column name, and the name of the string I am querying for. I have tried every variation of double and single quotes around each table name, column name, and name of string, and nothing worked.

For some reason, it seems that querying for a string is what is throwing everything off. I am new to postgres, am I missing something? Appreciate any advice possible
Reply | Threaded
Open this post in threaded view
|

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

Ron-2
On 1/3/21 7:33 PM, VAE Ventures wrote:
I am running a db on postgres12.4

I have been trying to run a query that looks like this:

SELECT * FROM table_1 INNER JOIN table_2 ON table_1.column = table_2.column WHERE table_1.column = ‘string’;

I am being returned:

ERROR: column 'string' does not exist

The following queries work fine:

SELECT * FROM table_1 INNER JOIN table_2 ON table_1.column = table_2.column WHERE table_1.column = int;

SELECT * FROM table_1 WHERE column = ‘string’;

I read several posts about this error, which seems very common and is usually solved by switching up quotation variations around the table name, column name, and the name of the string I am querying for. I have tried every variation of double and single quotes around each table name, column name, and name of string, and nothing worked.

For some reason, it seems that querying for a string is what is throwing everything off. I am new to postgres, am I missing something? Appreciate any advice possible

Please show us an actual query with it's actual error message.

--
Angular momentum makes the world go 'round.
Reply | Threaded
Open this post in threaded view
|

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

David G Johnston
In reply to this post by VAE Ventures
On Sun, Jan 3, 2021 at 6:33 PM VAE Ventures <[hidden email]> 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.