pode usar a contrib pg_trgm http://www.postgresql.org/docs/9.4/static/pgtrgm.html
E usar a saida do similarity como fator de agrupamento Em 13 de julho de 2015 11:53, Rebert Tomaz Aquino <[email protected]> escreveu: > alguém sabe se existem funções que agrupem informações parecidas.. ou até > alguem tem alguma lógica que ajude > > tipo.. > > tenho a seguinte estrutura: > > 5 mil linhas > 100 colunas > sendo > id,v1 .... v100 > xxx,xxx....xxxx > > problema: quero saber os 5 registros que tem os valores da coluna v59 > parecidos .. de preferencia fazer grupos distintos.. > > alguma solução? > > > > > -- > Rebert Tomaz > > > _______________________________________________ > pgbr-geral mailing list > [email protected] > https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral > > -- [image: CasBrasil Conexão Farma] <http://www.casbrasil.com.br/> [image: CasBrasil Conexão Farma] Fernando Foster Silva [email protected] +55 19 99222-0436 skype: casbrasil00 CasBrasil Conexão Farma +55 19 3368-4446 Avenida Itatiaia, 201, Jardim ItatiaiaCampinas - São Paulo http://www.casbrasil.com.br Fale com nossa equipe por skype casbrasil1 casbrasil02 casbrasil3 casbrasil4 casbrasil05 This e-mail message may contain confidential or legally privileged information and is intended only for the use of the intended recipient(s). Any unauthorized disclosure, dissemination, distribution, copying or the taking of any action in reliance on the information herein is prohibited. E-mails are not secure and cannot be guaranteed to be error free as they can be intercepted, amended, or contain viruses. Anyone who communicates with us by e-mail is deemed to have accepted these risks. Company Name is not responsible for errors or omissions in this message and denies any responsibility for any damage arising from the use of e-mail. Any opinion and other statement contained in this message and any attachment are solely those of the author and do not necessarily represent those of the company.
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
