beeps Comments - Answer Overflow

beeps

•Created by beeps on 12/30/2024 in #help-and-questions

TypedSql Array Parameter for Postgres

Hey Nurul - somewhat - here is the full query for the filtering scenario: https://pastebin.com/8bLK33rF The insert scenario is just

-- @param {String[]} $1:scanData String of scan data strings to insert
INSERT INTO scan_staging (scan_data)
SELECT unnest($1::text[]);

-- @param {String[]} $1:scanData String of scan data strings to insert
INSERT INTO scan_staging (scan_data)
SELECT unnest($1::text[]);

4 replies