Postgres Pro
Downloads
Home   >   mailing lists

Re: Need another set of eyes on this - Mailing list pgsql-general

From James B. Byrne
Subject Re: Need another set of eyes on this
Date
Msg-id e884ace5ef03e75368e39d6ea6c6d632.squirrel@webmail.harte-lyne.ca
Whole thread Raw
In response to Re: Need another set of eyes on this  ("aNullValue (Drew Stemen)" <drew@anullvalue.net>)
List pgsql-general
Tree view 

On Mon, January 25, 2021 14:19, aNullValue (Drew Stemen) wrote:

>
> You're using double-quotes rather than single-quotes for string values.
>
> "SHM" = column
> 'SHM' = string value
>


On Mon, January 25, 2021 14:19, Peter Coppens wrote:
>
> Try single quotes
>

Thank you both.

-- 
***          e-Mail is NOT a SECURE channel          ***
        Do NOT transmit sensitive data via e-Mail
   Unencrypted messages have no legal claim to privacy
 Do NOT open attachments nor follow links sent by e-Mail

James B. Byrne                mailto:ByrneJB@Harte-Lyne.ca
Harte & Lyne Limited          http://www.harte-lyne.ca
9 Brockley Drive              vox: +1 905 561 1241
Hamilton, Ontario             fax: +1 905 561 0757
Canada  L8E 3C3

pgsql-general by date:

Previous
From: Peter Coppens
Date:
Subject: Re: Need another set of eyes on this
Next
From: "Markhof, Ingolf"
Date:
Subject: Re: How to keep format of views source code as entered?