Re: RfD: more powerful "any" types - Mailing list pgsql-hackers

From Tom Lane
Subject Re: RfD: more powerful "any" types
Date
Msg-id 29368.1252503589@sss.pgh.pa.us
Whole thread Raw
In response to Re: RfD: more powerful "any" types  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: RfD: more powerful "any" types
Re: RfD: more powerful "any" types
Re: RfD: more powerful "any" types
Re: RfD: more powerful "any" types
List pgsql-hackers
Peter Eisentraut <peter_e@gmx.net> writes:
> Well, so far we've only seen use cases in this thread that either
> already work or that are not well-defined. ;-)

Well, yeah, the question is can we extract a clear TODO item here.

I think there are two somewhat orthogonal issues:

1. Is a completely unconstrained argument type (ie "any") of any real
use to PL functions, and if so how can we expose that usefulness?
The only clear thing to do with such an argument is IS NULL/IS NOT NULL
tests, which might or might not be worth the trouble.

2. Is there any use for arguments with type constraints not covered
by the existing ANYFOO rules, and if so what do we add for that?

One comment on point 2 is that it was foreseen from the beginning
that there would be need for ANYELEMENT2 etc, and I'm actually rather
surprised that we've gone this long without adding them.  Alvaro made
a good point about not wanting to multiply the various hard-wired
OID references, but perhaps some judicious code refactoring could
prevent a notational disaster.
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: COALESCE and NULLIF semantics
Next
From: Rafael Martinez
Date:
Subject: More robust pg_hba.conf parsing/error logging