Re: Data type OID numbers fixed? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Data type OID numbers fixed?
Date
Msg-id 26081.1215476476@sss.pgh.pa.us
Whole thread Raw
In response to Data type OID numbers fixed?  ("Stephen R. van den Berg" <srb@cuci.nl>)
List pgsql-hackers
"Stephen R. van den Berg" <srb@cuci.nl> writes:
>     case 16:   // _bool
>     case 17:   // _bytea
>     case 18:   // _char
>     case 20:   // _int8
>     case 21:   // _int2
>     case 23:   // _int4
>     case 25:   // _text
>     case 142:  // _xml
>     case 829:  // _macaddr
>     case 869:  // _inet
>     case 1042: // _bpchar
>     case 1043: // _varchar
>     case 1700: // _numeric
>     case 2950: // _uuid

> How large is the probability of these numbers ever changing?

Not very, but just on code readability grounds, you should use the
macros from pg_type.h instead of writing literal constants.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: PATCH: CITEXT 2.0
Next
From: "David E. Wheeler"
Date:
Subject: Re: PATCH: CITEXT 2.0