create type problem!
Hi all,
I am trying to create a data type which should be able to store 6 float
variables in one column. I am unable to figure out how I can write the
input, output functions that can be used in create type.
Is there any other way I can have my data in a single column ?
I am currently working with psql version 7.2.1.
Any help would be highly appreciated. Also, I am not subscribed in the
mailing lists, so kindly cc the reply to my e-mail id.
Thanks,
--
Lakshmi S.
********************************************
Department of Studies in Physics
University of Mysore, Manasagangotri
Mysore 570 006, INDIA
********************************************
Lakshmi S. wrote:
I am trying to create a data type which should be able to store 6 float
variables in one column. I am unable to figure out how I can write the
input, output functions that can be used in create type.Is there any other way I can have my data in a single column ?
Why not use a float array (e.g. float8[])?
Joe
"Lakshmi S." <lakshmi@uomphysics.net> writes:
I am trying to create a data type which should be able to store 6 float
variables in one column. I am unable to figure out how I can write the
input, output functions that can be used in create type.
Rather than reinventing this wheel, why don't you just use an array?
regards, tom lane