Re: PostgresQL 9.2 table query - underscores

"Victoria S." <1@VictoriasJourney.com> writes:
> 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)

It looks like you've put quotes into the stored data.  Not a good idea.

            regards, tom lane