Excerpts from Jeff Hamann's message of mar jul 20 17:59:01 -0400 2010: > select universedate,tradetimestamp,tradeprices from tradeprices where > date(tradetimestamp) = CURRENT_DATE order by tradetimestamp desc;
You're selecting the "whole row" as a column, which is why you get a row back in the third position -- try tradeprice instead of tradeprices. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general