2009/7/29 Marcos Bernardelli <[email protected]> > Bom dia senhores, estou tentando fazer o seguinte: > > FOR "RECORD" IN SELECT column_name FROM INFORMATION_SCHEMA.COLUMNS WHERE > column_name NOT IN ("VETOR") LOOP > ... > END LOOP; > > Onde o "VETOR" seria um array (Com uma única dimensão) definido da seguinte > maneira: > "VETOR" := '{"coluna1", "coluna2", "..."}'; > > Eu preciso que esse array e a clausula in seja montado dentro de uma > FUNCTION. > > Alguem já tentou fazer / fez algo parecido? > > > Veja se o exemplo abaixo ajuda:
postg...@bdteste=# select table_schema, table_name, column_name from information_schema.columns where column_name = ANY( ARRAY['relname', 'nspname'] ) ; table_schema | table_name | column_name --------------+--------------------------+------------- pg_catalog | pg_class | relname pg_catalog | pg_listener | relname pg_catalog | pg_namespace | nspname pg_catalog | pg_stat_all_tables | relname pg_catalog | pg_stat_sys_tables | relname pg_catalog | pg_stat_user_tables | relname pg_catalog | pg_statio_all_tables | relname pg_catalog | pg_statio_sys_tables | relname pg_catalog | pg_statio_user_tables | relname pg_catalog | pg_stat_all_indexes | relname pg_catalog | pg_stat_sys_indexes | relname pg_catalog | pg_stat_user_indexes | relname pg_catalog | pg_statio_all_indexes | relname pg_catalog | pg_statio_sys_indexes | relname pg_catalog | pg_statio_user_indexes | relname pg_catalog | pg_statio_all_sequences | relname pg_catalog | pg_statio_sys_sequences | relname pg_catalog | pg_statio_user_sequences | relname (18 rows) Cordialmente, -- Fabrízio de Royes Mello >> Blog sobre PostgreSQL: http://fabriziomello.blogspot.com
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
