Re: PostgresQL 9.2 table query - underscores

"Victoria S." <1(at)VictoriasJourney(dot)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