query on a table with an int and a vector of floating point numbers

From: Victor Whiskey Yankee <victor(dot)whiskey(dot)yankee(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: query on a table with an int and a vector of floating point numbers
Date: 2013-03-07 01:49:49
Message-ID: 5137F23D.6070003@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hello,
I have table that contains columns of various types, including ints, varchar and a vector of floating point numbers.

Is the int column and the column with the vector of numbers stored in a binary or native format?

How can I do a query on the table and retrieve the int and vector of numbers in their native binary formats?

Can I do so without the postgres-specific binary cursor? Can it be done without the overhead of converting from some serialized form
like a string?

An example would be great; I searched but found none.

Thanks,
Vic

Browse pgsql-novice by date

  From Date Subject
Next Message Justus Mugbeh 2013-03-10 00:49:14 Fw: 3/10/2013 1:49:12 AM
Previous Message Merlin Moncure 2013-03-06 03:54:39 Re: Writing your own aggregate functions