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
associatedwith 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
andpromote groups of 30 
 
days to numbers of months");