Re: Composite types in tables - Mailing list pgsql-general

From Chris Travers
Subject Re: Composite types in tables
Date
Msg-id 200403120917.00972.chris@travelamericas.com
Whole thread Raw
In response to Composite types in tables  ("Floyd Shackelford" <floyd@fwshackelford.com>)
List pgsql-general
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)


pgsql-general by date:

Previous
From: Jerry LeVan
Date:
Subject: Problem with Java during make install 7.4.1 and 7.4.2
Next
From: pw
Date:
Subject: What is the syntax for UPDATE from one table to another?