Postgres OIDs and box2d, box2df, box3d, and gidx: differences and usage?

[Paul Ramsey]

On Fri, Jun 7, 2024 at 1:49 AM Tom Payne <twpayne at gmail.com> wrote:

> obstacledb=# SELECT typname, oid FROM pg_type WHERE typname IN ('box2d', 'box2df', 'box3d', 'gidx');
>  typname |   oid
> ---------+---------
>  box3d   | 5248539
>  box2d   | 5248543
>  box2df  | 5248547
>  gidx    | 5248551
> (4 rows)

Oh, and you probably already know this, but just for completeness: the
Oid numbers of the PostGIS types will VARY between databases, because
they are assigned at run-time by the PostgreSQL server. So the Oid you
have for geometry will not be the same as the one I have.

ATB,
P