0

I am doing it in nodejs please guide me to get expected output in postgres

my table creation Query

CREATE TABLE IF NOT EXISTS "detailed_data" (
        "id" SERIAL,
        "data" VARCHAR(100) NOT NULL,
            "bike_used" int default 0,
        PRIMARY KEY ("data")
    );

Queries for data insertion

1.Query for bikes if it used at least once to update bike count to know how many time it used

(`UPDATE "detailed_data"  SET bike_used=bike_used+1 WHERE "data" = $1`,[data])

2.if bike is going to used first time

(`INSERT INTO "detailed_data" ("data") VALUES ($1) ON CONFLICT ("data") DO NOTHING`,[.data])

I have table like

ID  | data   | bike_used                 
1   |bike1   |  4        
2   |bike2   |  5         
3   |bike3   |  1

I want to get datatable ouput like

ID  | data   | bike_used  |    used_by            
1   |bike1   |  4         |    rohan,roy,jim,rocky
timdev
  • 1
  • 1
  • @a-horse-with-no-name can u suggest how to add in update query itself i am able to insert if bike used at first time – timdev Dec 15 '22 at 07:31

0 Answers0