Re: Type Categories for User-Defined Types - Mailing list pgsql-hackers

From David E. Wheeler
Subject Re: Type Categories for User-Defined Types
Date
Msg-id 88562268-F221-4C31-B435-868C03B88197@kineticode.com
Whole thread Raw
In response to Re: Type Categories for User-Defined Types  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Jul 29, 2008, at 14:33, Tom Lane wrote:

> That's exactly what I don't really want to do; if you are adding  
> aliases
> *only* to get rid of ambiguity-errors, and not to alter functionality,
> then I think you're doing the wrong thing.  Adding more aliases can
> easily make the situation worse.

Actually, most seem to resolve to text okay. I'm adding aliases to  
change behavior (e.g., case-insensitive matching in replace()). It's  
the bazillion cast functions I'm having to add that are annoying (see  
my previous post with the int8 example).

>> Anyway, would this issue then go away once the type stuff was added
>> and citext was specified as TYPE = 'S'?
>
> Yeah, that's the point of the proposal.  I think the issue has come up
> once or twice before, too, else I'd not be so interested in a general
> solution.  (digs in archives ... there was some discussion of this
> in connection with unsigned integer types, and I seem to recall older
> threads but can't find any right now.)

No worries, it seems like a really good idea to me, regardless.

Thanks!

David



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Type Categories for User-Defined Types
Next
From: Markus Wanner
Date:
Subject: Re: about postgres-r setup.