Re: [SQL] Interval subtracting

I've written the interval_justify() function but the parser does not know about
it yet. I changed these files:

backend/utils/adt/timestamp.c
include/catalog/pg_proc.h
include/utils/timestamp.h

I used grep -R to find all locations where interval_justify_time is mentioned,
and for each one added an analogous entry for my new function interval_justify.
But I get lost where OID=1175 is associated with interval_justify_time. I
can't really just grep for 1175 and add analogous entries of my new OID, because
I don't know what all the tables mean. (BTW, I grabbed the next slot in the
table and used OID=2711, but I don't know if that is the proper strategy for
adding new OIDs.)

Is there an automated way of handling this task, such as a developer tool that I
didn't find?

mark

Index: include/catalog/pg_proc.h
===================================================================
RCS file: /projects/cvsroot/pgsql/src/include/catalog/pg_proc.h,v
retrieving revision 1.399
diff -r1.399 pg_proc.h
1464a1465,1466
> DATA(insert OID = 2711 ( justify PGNSP PGUID 12 f f t f i 1
1186 "1186" _null_ _null_ _null_ interval_justify - _null_ ));
> DESCR("promote groups of 24 hours to numbers of days and promote groups of 30
days to numbers of months");