K
Kysely•9mo ago
djMax

How do you formulate a custom type argument?

I would like to pass a record type to a postgres function with kysely. How do I do that? I get "malformed record literal" when I try the obvious things. I'm sure I can raw-sql it together but I'd like to do it as properly as possible.
2 Replies
Igal
Igal•9mo ago
Hey 👋🏻 A playground link would help us understand better what you're trying to do
djMax
djMax•9mo ago
https://kyse.link/?p=s&i=STmJdHPmiE3OS3cyp4hj Not much there because kysely doesn't explicitly generate anything for functions or records, but I put the sql. I want to call that function. I made it work by changing the param to json and then doing 
  WITH cte AS (
    SELECT x
    FROM json_populate_recordset(NULL::identifier_detail, _jsonIdentifiers) AS x
  )
  WITH cte AS (
    SELECT x
    FROM json_populate_recordset(NULL::identifier_detail, _jsonIdentifiers) AS x
  )
in the function, but... ewww.
Want results from more Discord servers?
Add your server
More Posts
How do I type the arguments to a function?I am calling a stored proc with parameters (we have very few, but some make the client's life a lot InsertInto with all default values?How do I run the equivalent of ```INSERT INTO test DEFAULT VALUES returning``` in kysely?Can this query translate to kysely?```sql sql`SELECT frr.reimbursement_request_id, frr.reference_no, frrt.request_tyDeferred JoinHi - I'm experimenting with adding deferred join capability (as described here: (https://planetscaleStumped - sqlite kysely no data from select queryI have an electron app with `node-sqlite3` and `kysely`. I'm able to post data, but for some reasonMySQL Returning Statement AlternativeA while back I read online that MySQL does not support RETURNING statements at all. If that's the caIssue running migrations against MySQL databasePreviously I had to make the switch from Postgres to MySQL because the database I had in production Deno usageHey, has anyone by any chance trie using Kysely with deno using the `postgresjs` library? https://gi