I'm sorry if this not the appropriate place for this post, but I couldn't figure out where to put this and I didn't see anything online so far...
I've been prototyping a small database, with the following table definition:
drop table if exists tradeprices cascade;
create table tradeprices (
universedate date not null,
tradetimestamp timestamp not null,
tradeprice real[] not null,
primary key (universedate,tradetimestamp)
);
When I insert the following row,
insert into tradeprices (universedate,tradetimestamp,tradeprice) values ('2010-07-20','2010-07-20 14:31:02','{1076.09,84.1199,100.21,95.74,107.2822,105.2657,11.67,53.75,40.04,61.41,68.176,71.13,39.85,59.41,61.66,63.32,38.92,83.46,49.03,48.6999,108.21,34.18,54.1901,73.52,54.94,40.17,17.35,51.7,42,43.0195,52.419,41.7,41.8,55.57,35.14,28.31,19.17,18.0608,34.2}');
The results are printed as:
select universedate,tradetimestamp,tradeprices from tradeprices where date(tradetimestamp) = CURRENT_DATE order by tradetimestamp desc;
-[ RECORD 1 ]--+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
universedate | 2010-07-20
tradetimestamp | 2010-07-20 11:10:44
tradeprices | (2010-07-20,"2010-07-20 11:10:44","{1076.09,84.1199,100.21,95.74,107.282,105.266,11.67,53.75,40.04,61.41,68.176,71.13,39.85,59.41,61.66,63.32,38.92,83.46,49.03,48.6999,108.21,34.18,54.1901,73.52,54.94,40.17,17.35,51.7,42,43.0195,52.419,41.7,41.8,55.57,35.14,28.31,19.17,18.0608,34.2}")
where the "tradeprices" vector contains, in the print output only, the values of the previous columns in the row (see the first two elements of the tradeprices vector).
I've tried connecting to the database and retrieved to test connections using psql, ODBC drivers, RPostgreSQL, etc. and the results come back, depending on the client.
I was originally working with 8.3, and have only recently updated to 8.4
Is this a bug, or something that I'm not doing correctly, or both?
Respectfully,
Jeff.
Jeff Hamann
jeff.d.hamann@xxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
