Int2 vector to array equality

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org>
Subject: Int2 vector to array equality
Date: 2004-06-06 23:30:58
Message-ID: 40C3A932.5080108@pse-consulting.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

While trying to

pg_constraint JOIN pg_index ON indrelid=conrelid AND conkey=indkey

I noticed (once again) that these columns have different types (although
describing the same thing), and there's no equality operator for them.

The attached patch adds an equality operator
bool int2array_int2vector_eq(int2[], int2vector)

to enable this join.

Regards,
Andreas

Attachment Content-Type Size
int2arrayveceq.diff text/plain 3.4 KB

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2004-06-07 00:26:02 Re: Int2 vector to array equality
Previous Message Tom Lane 2004-06-05 18:18:12 Re: Tablespaces