From: | Morgan Kita <mkita(at)verseon(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Custom types and array equality |
Date: | 2006-10-21 01:16:28 |
Message-ID: | 1161393388.11296.4.camel@localhost.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
This should be a relatively simple question... I just made a custom type
in C, which I will use to build an array in one of my tables. I defined
an equality function in C, and declared an operator = on my custom type
that calls my equality operator.
Along the lines of:
CREATE OPERATOR = (
leftarg = mytype, rightarg = mytype, procedure = mytype_equal,
commutator = =
);
However, I cant seem to add a useful unique constraint on the table that
includes a column of type mytype[]. When I insert a new record it
complains that it can't find a comparison operator for the type. I did a
bit of digging and found in array.c that error message is produced when
calling array_cmp and the type has no defined comparison operator...
However, should array_eq be called for unique constraints? What am I
missing here to get this system working? The operator itself works when
I call it explicitly on two arrays of mytype.
Thanks for any help ahead of time!
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2006-10-21 02:35:58 | Re: c (lowercase) privilege |
Previous Message | Gregory S. Williamson | 2006-10-21 01:02:16 | Re: Question with tsearch2 (or it might be a general one too) |