Type "int[]" does not exist when using dynamic values for casting

[aemonm]

I have the following statement to as part of a larger query:
sql`AND my_table.some_column = ANY(${values}::${pgSql(type)}[])`

When type is text, it works as expected. When type is int I get the following error:
Error [PostgresError]: type "int[]" does not exist

Shouldn't I be able to use dynamic type casting for both text and int ?

[charmander]

Yes, that should work. It’s probably an entirely PostgreSQL-side issue, though, and not something introduced by this client.

• Are you able to reproduce the issue with a different client, e.g. psql?
• Which PostgreSQL server version (or PostgreSQL-compatible alternative database) are you using?
• Do casts to integer[] work? How about just int?

[aemonm]

Interesting, it looks like this is an issue with our Postgres version indeed. I can reproduce it running a raw query in version 14. Both using integer and int give errors but no issues with using text. Thank you.