Bruce Momjian wrote:
>
> > > I think there are a few rules we can use to decide how to deal with
> > > imperfect solutions:
> >
> > You forgot
> >
> > * will the fix institutionalize user-visible behavior that will in the
> > long run be considered the wrong thing?
> >
> > * will the fix contort new code that is written in the same vicinity,
> > thereby making it harder and harder to replace as time goes on?
> >
> > The first of these is the core of my concern about %TYPE.
>
> I was thinking about this. Seems if we want to emulate Oracle, we have
> to make %TYPE visible the way it is implemented in the patch. We can
> make it track table changes or not, but it doesn't seem we have much
> latitude in how we make it visible to users.
I think Tom's argument was that just making it visisble will tie us up
to
also keep the semantics, which will be subtly different in PostgreSQL
and
Oracle and which can't be exactly emulated without emulating
_everything_
in Oracle and thereby throwing away unique strengths of PostgreSQL.
Fortunately I've not heard very much support for making empty string and
NULL to be the same ;)
-----------------
Hannu