Thread: 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