[Enhancement]: Remove instances of relnamespace::regnamespace casting in system view, function, or procedure implementations

[avneet-toor-bq]

Contact Details

[email protected]

What this feature/enhancement tries to solve?

In some system view, function, or procedure implementations we see relnamespace::regnamespace casting going on. For example:

select 
...
from pg_class t
where t.relnamespace::regnamespace::text = 'sys';

This kind of casting should be avoided. Modify the system object implementation to remove this casting but still have the view/function/procedure work correctly.

If want to provide us a more details about how to implement.

No response

Version

babelfishpg_tsql (Default)

Relevant documentation

No response

Code of Conduct

• I agree to follow this project's Code of Conduct

[nasbyj]

Also, there's really no reason for there to be two "levels" on these views. Instead of

SELECT CAST(object_id AS int) ...
  FROM (SELECT i.indrelid AS object_id ...)

Just do

SELECT i.indrelid::int AS object_id

(or CAST (i.indrelid AS int) AS object_id if you prefer)