Subject: Re: Postgres 12.4 inner join with where statement = 'string'
 returning error
To: pgsql-admin@lists.postgresql.org
References: 
 <BL0PR02MB537917C08B815DEF89BF99D7B6D20@BL0PR02MB5379.namprd02.prod.outlook.com>
From: Ron <ronljohnsonjr@gmail.com>
Message-ID: <3e55a385-08b3-96a7-dc84-cc34e0adbf4a@gmail.com>
Date: Sun, 3 Jan 2021 20:45:08 -0600
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101
 Thunderbird/68.10.0
MIME-Version: 1.0
In-Reply-To: 
 <BL0PR02MB537917C08B815DEF89BF99D7B6D20@BL0PR02MB5379.namprd02.prod.outlook.com>
Content-Type: multipart/alternative;
 boundary="------------38DC99E29A8128DD4C1E8FD6"
Content-Language: en-US
Precedence: bulk

This is a multi-part message in MIME format.
--------------38DC99E29A8128DD4C1E8FD6
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit

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.

--------------38DC99E29A8128DD4C1E8FD6
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 8bit

<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    On 1/3/21 7:33 PM, VAE Ventures wrote:<br>
    <blockquote type="cite"
cite="mid:BL0PR02MB537917C08B815DEF89BF99D7B6D20@BL0PR02MB5379.namprd02.prod.outlook.com">
      <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
      <style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
      <div style="font-family: Calibri, Arial, Helvetica, sans-serif;
        font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255,
        255, 255);">
        I am running a db on postgres12.4
        <div><br>
        </div>
        <div>I have been trying to run a query that looks like this:</div>
        <div><br>
        </div>
        <div>SELECT * FROM table_1 INNER JOIN table_2 ON table_1.column
          = table_2.column WHERE table_1.column = ‘string’;</div>
        <div><br>
        </div>
        <div>I am being returned:</div>
        <div><br>
        </div>
        <div>ERROR: column 'string' does not exist</div>
        <div><br>
        </div>
        <div>The following queries work fine:</div>
        <div><br>
        </div>
        <div>SELECT * FROM table_1 INNER JOIN table_2 ON table_1.column
          = table_2.column WHERE table_1.column = int;</div>
        <div><br>
        </div>
        <div>SELECT * FROM table_1 WHERE column = ‘string’;</div>
        <div><br>
        </div>
        <div>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.
        </div>
        <div><br>
        </div>
        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<br>
      </div>
    </blockquote>
    <br>
    Please show us an actual query with it's actual error message.<br>
    <br>
    <div class="moz-signature">-- <br>
      Angular momentum makes the world go 'round.</div>
  </body>
</html>

--------------38DC99E29A8128DD4C1E8FD6--