Este SQL gera dinamicamente o select desejado:
SELECT 'SELECT MAX(data) AS maior_data FROM ('||array_to_string(array(
SELECT 'SELECT max('||column_name||') AS data FROM '||table_name
FROM information_schema.columns
WHERE table_schema = 'public'
AND column_name = 'data'
),' union ')||') as t' AS selects;Atenciosamente, Alessandro Lima
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
