Nil Comments - Answer Overflow

Nil

Posts Comments

KKysely

•Created by Nil on 8/31/2023 in #help

hi, how do i make a select with a where that searches within a json? I'm using postgres

8 replies

KKysely

•Created by Nil on 8/31/2023 in #help

hi, how do i make a select with a where that searches within a json? I'm using postgres

im using postgres

8 replies

KKysely

•Created by Nil on 8/8/2023 in #help

how to insert an array of strings

@koskimas It is returning QueryCompilerError: Could not serialize value when I try to register

6 replies

KKysely

•Created by Nil on 6/12/2023 in #help

insert data into a table that has id of type bigserial

Hey, I found the problem, I had to specify the type in the json declaration, like this:

    const obj = {
      nome: "nil", 
      sobrenome: "kuro"
    }
    const json = JSON.stringify(obj)
    console.log(json)
    const responseDb = await db
    .withSchema("dukeRecurrency")
    .insertInto('administrator')
    .values({
      "cognitoId": "nil", 
      "asaasSubaccountInfo": sql`${json}::json`
    })
    .execute()

    const obj = {
      nome: "nil", 
      sobrenome: "kuro"
    }
    const json = JSON.stringify(obj)
    console.log(json)
    const responseDb = await db
    .withSchema("dukeRecurrency")
    .insertInto('administrator')
    .values({
      "cognitoId": "nil", 
      "asaasSubaccountInfo": sql`${json}::json`
    })
    .execute()

6 replies

KKysely

•Created by Nil on 6/7/2023 in #help

I am getting an error when entering an id with a uuid value

I found it very difficult to work with him, thanks for the help!

7 replies

KKysely

•Created by Nil on 6/7/2023 in #help

I am getting an error when entering an id with a uuid value

wow, thanks, it's worked!

7 replies

Gaming

Programming