DEFINITIONS

Definitions More Info.
Definition ID927
TitlePOSTGRESQL
CategoryNOTES
Definitionunnest string to array - row to column
Definition DescriptionSELECT 'scaliskan,ocaliskan,aoztayinci,since', string_to_array('scaliskan,ocaliskan,aoztayinci,since', ',')
SELECT * fROM unnest( string_to_array('scaliskan,ocaliskan,aoztayinci,since', ',') ) a

SELECT *
fROM unnest( string_to_array( (SELECT replace(replace( csv("ID"::text), ''',''', ','), '''', '') FROM "ERP"."Company" WHERE "ID" BETWEEN 11 AND 120), ',' )) a
JOIN "ERP"."Employee" ON a.a::bigint = "Employee"."CompanyID"

SELECT * FROM "ERP"."Company" WHERE "ID" IN (SELECT "ID" FROM "ERP"."Company" WHERE "ID" BETWEEN 11 AND 120)
SELECT * FROM "ERP"."Company" WHERE "ID" = ANY( string_to_array( (SELECT replace(replace( csv("ID"::text), ''',''', ','), '''', '') FROM "ERP"."Company" WHERE "ID" BETWEEN 11 AND 120), ',' )::bigint[] )
RecordBycunay
Record Date05-04-2019 15:57:49
Düzenle
Kopyala
Sil