Table emulation in postgres and mysql

mysql.sql

SELECT * 
FROM 
 (
   SELECT 'juan' AS data UNION
   SELECT 'carlos' AS data UNION
   SELECT 'pepito' AS data UNION
   SELECT 'mauro' AS data
 ) AS tmp_names
WHERE
  -- Compare data with a real table 
  dato NOT IN (SELECT name FROM tbl_names)

postgres.sql

SELECT (
  '{{"DG54362","13668"},
  {"SCCC114952","1125137"},
  {"SCCC108226","35860"},
  {"SCCC48986","37257"},
  {"SCCC155903","9790"}}'::varchar[][])[foo][1] AS nrofactura,
('{{"DG54362","13668"},
  {"SCCC126619","37180"},
  {"SCCC126622","10018"},
  {"SCCC137446","169620"},
  {"SCCC155903","9790"}}'::varchar[][])[foo][2] AS valorfactura
FROM
  generate_series(1,5) AS foo