"Victoria S." <[email protected]> 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 ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
