Skip to content

Select Table with raw json_agg using DB PostgreSQL on Knex #5975

Closed
@lucasdzuc

Description

@lucasdzuc

I'm trying to make a query with Raw where I pass the 'json_agg' parameter to select the attributes of the 'memories' table, but it is returning duplicate objects, it should only return 2 objects instead of 4. Does anyone know what is causing this error ?

image

RESULT INSOMNIA - Objects duplicate
image

Terminal Log:
image

Knex Version: ^0.95.7

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions