On Tue, Aug 8, 2017 at 4:12 PM, Mark Rofail <[email protected]> wrote:
> On Tue, Aug 8, 2017 at 2:25 PM, Alexander Korotkov <[email protected]> > wrote: >> >> Do we already assume that default btree opclass for array element type >> matches PK opclass when using @>> operator on UPDATE/DELETE of referenced >> table? >> > I believe so, since it's a polymorphic function. > > >> If so, we don't introduce additional restriction here... >> > You mean to remove the wrapper query ? > I think we should choose the query which would be better planned (and presumably faster executed). You can make some experiments and then choose the query. > GROUP BY would also use default btree/hash opclass for element type. It >> doesn't differ from DISTINCT from that point. >> > Then there's no going around this limitation, > That seems like this. ------ Alexander Korotkov Postgres Professional: http://www.postgrespro.com The Russian Postgres Company
