Composite types in tables - Mailing list pgsql-general

From Floyd Shackelford
Subject Composite types in tables
Date
Msg-id E1AyE5d-0005Ra-Cd@dagny.betterthanyours.com
Whole thread Raw
Responses Re: Composite types in tables
List 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/>





pgsql-general by date:

Previous
From: satish satish
Date:
Subject: Data Corruption in case of abrupt failure
Next
From: Bill Moran
Date:
Subject: Re: Shouldn't B'1' = 1::bit be true?