Re: PostgresQL 9.2 table query - underscores

John R Pierce <pierce@xxxxxxxxxxxx> · Tue, 16 Jul 2013 15:17:15 -0700

    On 7/16/2013 3:04 PM, Victoria S.
      wrote:

      Hello: My first post; a Postgres newbie ...

I am teaching myself PostgresQL using a trial database, and I am having trouble with underscores:

IN the following example,

development=# SELECT created_at, username FROM tweets;
            created_at             |     username      
-----------------------------------+-------------------
 created_at                        | username
 “Tue, 12 Feb 2013 08:43:09 +0000″ | “_DreamLead”
 “Tue, 12 Feb 2013 07:31:06 +0000″ | “GunnarSvalander”
 “Tue, 12 Feb 2013 07:30:24 +0000″ | “GEsoftware”
 “Tue, 12 Feb 2013 06:58:22 +0000″ | “adrianburch”
 “Tue, 12 Feb 2013 05:29:41 +0000″ | “AndyRyder5″
 “Tue, 12 Feb 2013 05:24:17 +0000″ | “AndyRyder5″
 “Tue, 12 Feb 2013 01:49:19 +0000″ | “Brett_Englebert”
 “Tue, 12 Feb 2013 01:31:52 +0000″ | “Brett_Englebert”
 “Mon, 11 Feb 2013 23:15:05 +0000″ | “NimbusData”
 “Mon, 11 Feb 2013 22:15:37 +0000″ | “SSWUGorg”
(11 rows)

... why doesn't his work? :

development=# SELECT created_at, username FROM tweets WHERE username='_DreamLead';
 created_at | username 
------------+----------
(0 rows)

    try ....

      SELECT created_at, username FROM tweets WHERE username='“_DreamLead”';

    it appears you've stored those cute-quotes “ ” 
    in the field.

    -- 
john r pierce                                      37N 122W
somewhere on the middle of the left coast