Composite types in tables

From: "Floyd Shackelford" <floyd(at)fwshackelford(dot)com>
To: "Pgsql-General" <pgsql-general(at)postgresql(dot)org>
Cc: "Josh Wardle" <josh(at)truckmaster(dot)com>
Subject: Composite types in tables
Date: 2004-03-02 17:53:56
Message-ID: E1AyE5d-0005Ra-Cd@dagny.betterthanyours.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general


Are there any plans for PostGreSQL to support something like the following
without having to write specialized C code for each type? (or maybe it
already does?)

create type a_type ( field_a int, field_b int );
create table a_table ( a_column a_type );

If i try this now, i get "column 'a_column' has composite type 'a_type'".

Seems like PostGreSQL should be able to figure out the mapping for me
without having to resort to writing my own C extension.

Regards,

Floyd Shackelford

The Philosophy of Liberty: http://www.isil.org/resources/introduction.swf
<http://www.isil.org/resources/introduction.swf>

Liberty in Our Lifetime: http://www.freestateproject.org/
<http://www.freestateproject.org/>

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-03-02 17:54:16 Re: Max/min of 2 values function, plpgsql efficency?
Previous Message Bruno Wolff III 2004-03-02 17:38:28 Re: max table size