Search
Star
Feedback
Setup for Free
© 2026 Hedgehog Software, LLC
Twitter
GitHub
Discord
System
Light
Dark
More
Communities
Docs
About
Terms
Privacy
TypedSql Array Parameter for Postgres - Prisma
P
Prisma
•
15mo ago
•
5 replies
beeps
TypedSql Array Parameter for Postgres
I am attempting to use array parameters as inputs to my queries
, but when I generate the client I get the following error
:
Error
: SQL documentation parsing
: invalid type
:
'Int
[
]
'
(accepted types are
:
'Int
'
,
'BigInt
'
,
'Float
'
,
'Boolean
'
,
'String
'
,
'DateTime
'
,
'Json
'
,
'Bytes
'
,
'Decimal
'
)
at
'
{Int
[
]
}
$
1
:groupIds Array of group IDs to process
'
.
If I don
't include the
[
]
- the input parameter is not of an array type
. I am using this in two scenarios
: one with an
ANY()
ANY()
filter in my where clause
, and the other as an
unnest($1::text[])
unnest($1::text[])
for inserting an array
Prisma
Join
The official Discord server of Prisma! Find us online at prisma.io
9,819
Members
View on Discord
Resources
ModelContextProtocol
ModelContextProtocol
MCP Server
Recent Announcements
Similar Threads
Was this page helpful?
Yes
No
Similar Threads
TypedSQL Cannot Determine Data Parameter for Array
P
Prisma / help-and-questions
8mo ago
Passing an array into TypedSQL query
P
Prisma / help-and-questions
2y ago
TypedSQL for SQL Server?
P
Prisma / help-and-questions
16mo ago
TypedSQL Apostrophe
P
Prisma / help-and-questions
7mo ago