Here’s my multi-statment query:
INSERT INTO public.books("bookID", title, author, publisher, "publicationDate", "coverType", status, "categoryID")
VALUES (DEFAULT, $1, $2, $3, $4, $5, DEFAULT, $6);
SELECT b."bookID", b.title, b.author, b.publisher, b."publicationDate", b."coverType", c.name
FROM public.books b
INNER JOIN public.categories c ON b."categoryID" = c."categoryID"
WHERE b.status = 'false';
I need to merge it for my backend endpoint but it doesn’t work with RETURNING. How can I do that?