>>E qual é a saída da consulta: SELECT t.oid, typname, COUNT(*) FROM pg_class c INNER JOIN pg_type t ON (c.oid = typrelid) WHERE typrelid <> 0 GROUP BY t.oid, typname HAVING COUNT(*) > 1;
oid typname count 20674 pg_toast_20670 2 Att, Deliane Andrade 2013/11/7 Euler Taveira <[email protected]> > On 07-11-2013 12:37, Deliane Andrade wrote: > > Ao comentar o CASE em qualquer das consultas elas executam sem problema. > > > E qual é a saída da consulta: > > SELECT t.oid, typname, COUNT(*) FROM pg_class c INNER JOIN pg_type t ON > (c.oid = typrelid) WHERE typrelid <> 0 GROUP BY t.oid, typname HAVING > COUNT(*) > 1; > > > -- > Euler Taveira Timbira - http://www.timbira.com.br/ > PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento > _______________________________________________ > pgbr-geral mailing list > [email protected] > https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral >
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
