Re: VARIANT / ANYTYPE datatype

From: Darren Duncan <darren(at)darrenduncan(dot)net>
To: Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, Joseph Adams <joeyadams3(dot)14159(at)gmail(dot)com>, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
Subject: Re: VARIANT / ANYTYPE datatype
Date: 2011-05-11 19:25:31
Message-ID: 4DCAE2AB.6060309@darrenduncan.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

To follow-up my earlier comments ...

I suspect for practical purposes we may want to limit the scope of some type
features.

For example, the greatest benefits for "open union" / "mixin" types is with
routines/operators, not so much with tables.

So, Pg could choose to support open unions but only for routines, where the
declared types of table columns must still be other types. Then you don't have
to worry about searching your data for where one might be used, but only search
your system catalog for routines/operators that use it.

But closed unions should be supported in tables too.

-- Darren Duncan

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2011-05-11 20:04:22 Re: Patch to allow domains over composite types
Previous Message Noah Misch 2011-05-11 19:12:49 Re: Re: 4.1beta1: ANYARRAY disallowed for DOMAIN types which happen to be arrays