2 replies

Struggling with `MERGE` and `VALUES` Table Creation in Effect Typescript Library

I am currently struggling creating

MERGE

MERGE

and

CTE

CTE

expressions. In particular I want to create just a

VALUES

VALUES

table, but am unable to do so (I think) help would be appreciated, basically I want to generate something like:

USING (VALUES ($127,$128,$129),...) AS source("user_id","category_id","relationship")

USING (VALUES ($127,$128,$129),...) AS source("user_id","category_id","relationship")

insert

insert

constructor as a hack, but that obv. didn't work. Any. help would be appreciated!

2 replies

I am currently struggling creating

MERGE

MERGE

and

CTE

CTE

expressions. In particular I want to create just a

VALUES

VALUES

table, but am unable to do so (I think) help would be appreciated, basically I want to generate something like:

USING (VALUES ($127,$128,$129),...) AS source("user_id","category_id","relationship")

USING (VALUES ($127,$128,$129),...) AS source("user_id","category_id","relationship")

insert

insert

constructor as a hack, but that obv. didn't work. Any. help would be appreciated!