Skip to content

[pg] Support USING #1732

@rekby

Description

@rekby

Query:

SELECT pg_type.oid, typname   
FROM pg_catalog.pg_type   
LEFT   JOIN (select ns.oid as nspoid, ns.nspname, r.r         
  from pg_namespace as ns           
join ( select s.r, (current_schemas(false))[s.r] as nspname                   
 from generate_series(1, array_upper(current_schemas(false), 1)) as s(r) ) as r          using ( nspname )        ) as sp     
ON sp.nspoid = typnamespace  
WHERE typname = $1  ORDER BY sp.r, pg_type.oid DESC LIMIT 1

Error:

Status: GENERIC_ERROR
Issues: 
<main>:1:1: Error: JoinExpr: unsupported using

Metadata

Metadata

Assignees

Labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions