Re: [HACKERS] GSoC 2017: Foreign Key Arrays - Mailing list pgsql-hackers

From Mark Rofail
Subject Re: [HACKERS] GSoC 2017: Foreign Key Arrays
Date
Msg-id CAJvoCuusYZvvLKY=5FuipynY8VTC86Q_6AM=cw4C+WPgjkwytA@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] GSoC 2017: Foreign Key Arrays  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Responses Re: [HACKERS] GSoC 2017: Foreign Key Arrays
List pgsql-hackers
On Wed, Jul 12, 2017 at 12:53 AM, Alvaro Herrera <alvherre@2ndquadrant.com> wrote:
We have one opclass for each type combination -- int4 to int2, int4 to
int4, int4 to int8, etc.  You just need to add the new strategy to all
the opclasses.
 
Can you clarify this solution ? I think another solution would be external casting 

BTW now that we've gone through this a little further, it's starting to
look like a mistake to me to use the same @> operator for (anyarray,
anyelement) than we use for (anyarray, anyarray).
 
I agree. Changed to @>> 

Best Regards,
Mark Rofail 

pgsql-hackers by date:

Previous
From: Sandeep Thakkar
Date:
Subject: [HACKERS] pl/perl extension fails on Windows
Next
From: Thomas Munro
Date:
Subject: [HACKERS] DSA on 32 bit systems