T1ae1Ark

1SELECT * FROM db.table WHERE uuid::varchar LIKE ('389519a6-ba79-4a4d-a696-c818808d3b26');
2	
3queries[0] = "DROP FUNCTION createtemptable(text,text,text);"
4            + "CREATE OR REPLACE FUNCTION createTempTable(name TEXT, id TEXT, units TEXT) "
5            + "RETURNS void AS $$ "
6            + "BEGIN "
7            + "EXECUTE "
8            + "'CREATE TABLE IF NOT EXISTS db.' || name || id || "
9            + "' AS SELECT * FROM db.' || name || "
10            + "' WHERE uuid::varchar IN (' || units || ')';"
11            + "END; $$ "
12            + "LANGUAGE plpgsql;";
13	
14DROP FUNCTION createtemptable(text,text,text);
15CREATE OR REPLACE FUNCTION createTempTable(name TEXT, id TEXT, units TEXT) 
16RETURNS void AS $$ BEGIN EXECUTE 
17    'CREATE TABLE IF NOT EXISTS db.' || name || id || ' AS 
18         SELECT * FROM db.' || name || ' 
19         WHERE uuid IN (' || units || ')';
20END; $$ LANGUAGE plpgsql;
21	
22org.postgresql.util.PSQLException: Error: Syntaxerror at „a6“