Re: printing vector column seems to print the rest of the row too

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Jeff Hamann <jeff(dot)d(dot)hamann(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: printing vector column seems to print the rest of the row too
Date: 2010-07-20 22:06:48
Message-ID: 1279663544-sup-6080@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Brett Hoerner 2010-07-20 23:27:46 Problem with pg_try_advisory_lock and two connections (seemingly) getting the same lock
Previous Message Jeff Hamann 2010-07-20 21:59:01 printing vector column seems to print the rest of the row too