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

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: printing vector column seems to print the rest of the row too
Дата
Msg-id 1279663544-sup-6080@alvh.no-ip.org
обсуждение исходный текст
Ответ на printing vector column seems to print the rest of the row too  (Jeff Hamann <jeff.d.hamann@gmail.com>)
Список 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
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 по дате отправления:

Предыдущее
От: Jeff Hamann
Дата:
Сообщение: printing vector column seems to print the rest of the row too
Следующее
От: Brett Hoerner
Дата:
Сообщение: Problem with pg_try_advisory_lock and two connections (seemingly) getting the same lock