Search
Star
Feedback
Setup for Free
© 2026 Hedgehog Software, LLC
Twitter
GitHub
Discord
System
Light
Dark
More
Communities
Docs
About
Terms
Privacy
Unwanted db.execute() behavior; trying to pass in an array instead of a record or its singular - Drizzle Team
DT
Drizzle Team
•
3y ago
•
50 replies
some1chan
Unwanted db.execute() behavior; trying to pass in an array instead of a record or its singular
When trying to pass an array
(ex
.
number[]
number[]
,
bigint[]
bigint[]
,
string[]
string[]
) that contains only one element into
sql``
sql``
, it will be transformed into their non
-list type
(ex
.
number
number
,
bigint
bigint
,
string
string
respectively
)
.
When I put two elements in
, it then turns into a Postgres record
, which is not what I want
. What I expect is that the array stays an array
.
Drizzle Team
Join
The official Discord for all Drizzle related projects, such as Drizzle ORM, Drizzle Kit, Drizzle Studio and more!
11,879
Members
View on Discord
Resources
ModelContextProtocol
ModelContextProtocol
MCP Server
Recent Announcements
Similar Threads
Was this page helpful?
Yes
No
Next page
Similar Threads
Trying to pass transactions or db
DT
Drizzle Team / help
16mo ago
Getting an object instead of an array.
DT
Drizzle Team / help
2y ago
Problem when trying to execute raw query... (missing db.execute)
DT
Drizzle Team / help
3y ago
Trying to pass a variable in .having()
DT
Drizzle Team / help
2y ago