Re: [GENERAL] PostgresQL 9.2 table query - underscores

[Tom Lane]

"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


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general