

why there are no operators +-*/ to oid data type ?



Mon, 5 Jan 2004 09:17:37 +0100 (CET)
ivan <iv@psycho.pl>
operators +/- with oids
ivan <iv@psycho.pl> writes:
> why there are no operators +-*/ to oid data type ?

Why should there be?  Addition on OIDs seems like a meaningless
operation, at least for the intended usage of OIDs (namely as
opaque identifiers).

Yes, I know we have < and >= and similar operators on OID, but those
are only there to support btree indexes on OIDs.  Equality is the only
user-meaningful operator in the lot, IMHO.

If you are desperate you can cast OID to int4 and then arithmetize it
all you want.

			regards, tom lane

Mon, 05 Jan 2004 03:31:01 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: operators +/- with oids 