"Victoria S." <1@xxxxxxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
