ET
08/25/2020, 7:31 AMEXISTS(SELECT size from file where path = '/tmp/et.txt')
I get this error : "Error: near "EXISTS": syntax error"
Maybe do you have a different solution instead of "EXISTS" ?seph
ET
08/25/2020, 1:16 PMSELECT 'true' AS is_present FROM file WHERE path = '/tmp/et.txt'
CASE
logic as follows:
SELECT CASE WHEN (SELECT 1 FROM file WHERE path = '/tmp/et.txt') THEN 'true' ELSE 'false' END AS file_present
ET
08/25/2020, 1:29 PM