Lists: | pgsql-general |
---|
From: | "Lakshmi S(dot)" <lakshmi(at)uomphysics(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | create type problem! |
Date: | 2003-03-27 06:09:58 |
Message-ID: | 20030327060958.GA878@aapa.xrdlab.mysore |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
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
********************************************
From: | Joe Conway <mail(at)joeconway(dot)com> |
---|---|
To: | "Lakshmi S(dot)" <lakshmi(at)uomphysics(dot)net> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: create type problem! |
Date: | 2003-04-01 18:46:26 |
Message-ID: | 3E89DE82.8090903@joeconway.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
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
From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | "Lakshmi S(dot)" <lakshmi(at)uomphysics(dot)net> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: create type problem! |
Date: | 2003-04-01 19:10:37 |
Message-ID: | 2328.1049224237@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
"Lakshmi S." <lakshmi(at)uomphysics(dot)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