neondatabase / neondatabase/serverless
[Question] How to call a stored procedure that has a composite type argument
Open
Nobody has claimed this yet.
- Dominant language
- JavaScript
- Stars
- 548
- Forks
- 81
- PR merge metrics
- No merged PRs in 30d
Description
I checked the docs and examples (maybe missed something), but as I see, there are only simple queries. I am interested in a more complex scenario, for example:
CREATE TYPE schema.compositeType AS
(
id integer, name text, email text, phone text
);
CREATE OR REPLACE PROCEDURE schema.importCompositeType(IN args schema.compositeType[])
Is it possible to make a call for such code with the latest version of the driver?
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by reviewing the driver's documentation and examples, then inspect how it handles PostgreSQL procedure calls and composite-type array arguments. Done means establishing whether the latest driver supports this call and documenting the supported usage or clearly recording the missing capability.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- javascript, postgresql
- Domain
- database
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100