watford-ep commented on issue #18327:
URL: https://github.com/apache/datafusion/issues/18327#issuecomment-3457043735
I found a simpler repo which does not require the `pg_catalog` shims from
`datafusion-postgres`:
```sql
WITH typ(oid, typnamespace, typname, typtype) AS (
SELECT * FROM (VALUES (1, 10, 't1', 'b'))
UNION ALL SELECT * FROM (VALUES (2, NULL, 't2', 'b'))
UNION ALL SELECT * FROM (VALUES (3, 12, 't3', NULL))
)
, ns(oid, nspname) AS (VALUES (1, 'ns1'), (2, 'ns2'))
SELECT ns.nspname, typ.oid, typ.typname, typ.typtype
FROM typ JOIN ns ON (ns.oid = typ.typnamespace)
WHERE typ.typtype IN ('b','r','m','e','d')
ORDER BY CASE WHEN typ.typtype IN ('b','e','p') THEN 0
WHEN typ.typtype = 'r' THEN 1
END
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
