Thread: Composite types in tables

Composite types in tables

From
"Floyd Shackelford"
Date:
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/>





Re: Composite types in tables

From
Chris Travers
Date:
This has been recently covered in a discussion both on this list and on
Hackers.  It is not easy to do, apparently, but it is on the radar.

Check the archives.

Best Wishes,
Chris Travers

On Tuesday 02 March 2004 09:53, you wrote:
> 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/>
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)