Re: Coercing compound types to use generic ROW comparison operators - Mailing list pgsql-general

From Tom Lane
Subject Re: Coercing compound types to use generic ROW comparison operators
Date
Msg-id 12212.1192140674@sss.pgh.pa.us
Whole thread Raw
In response to Re: Coercing compound types to use generic ROW comparison operators  (Randall Lucas <rlucas@tercent.com>)
Responses Re: Coercing compound types to use generic ROW comparison operators  ("Merlin Moncure" <mmoncure@gmail.com>)
List pgsql-general
Randall Lucas <rlucas@tercent.com> writes:
> Still, this would fail in a nested situation because it wouldn't
> recurse (if col1 of the compound type were another compound type,
> ferinstance), as would your suggestion above.  It might be worthwhile
> to allow choosing to use the default ROW comparison operator at
> composite type creation (which would provide a more elegant solution to
> nested situations).

You are incorrectly supposing that there *is* such an animal as a
default row comparison operator --- actually, ROW() = ROW() is expanded
at parse time into field-by-field comparisons.  This is usually a good
thing since it gives the planner more flexibility.

            regards, tom lane

pgsql-general by date:

Previous
From: Randall Lucas
Date:
Subject: Re: Coercing compound types to use generic ROW comparison operators
Next
From: "Carlos H. Reimer"
Date:
Subject: RES: RES: 8.2.4 selects make applications wait indefinitely