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