Postgres Pro
Downloads
Home   >   mailing lists

Re: printing vector column seems to print the rest of the row too - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: printing vector column seems to print the rest of the row too
Date
Msg-id 1279663544-sup-6080@alvh.no-ip.org
Whole thread Raw
In response to printing vector column seems to print the rest of the row too  (Jeff Hamann <jeff.d.hamann@gmail.com>)
List pgsql-general
Tree view 
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
tradetimestampdesc; 

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.

pgsql-general by date:

Previous
From: Jeff Hamann
Date:
Subject: printing vector column seems to print the rest of the row too
Next
From: Brett Hoerner
Date:
Subject: Problem with pg_try_advisory_lock and two connections (seemingly) getting the same lock