> > > Em 02-04-2014 18:30, Fábio Telles Rodriguez escreveu: > >> > >> Roda aí.... > >> > >> select * from > >> (select array_to_string(array_agg(CASE WHEN > >> (power((xx.x-25),2)/130+power((yy.y-25),2)/130)=1 THEN ' > >> WHEN (sqrt(power(xx.x-20,2)+power(yy.y-20,2)))<2 THEN '#' WHEN > >> (sqrt(power(xx.x-20,2)+power(yy.y-30,2)))<2 THEN '#' WHEN > >> (sqrt(power(xx.x-29,2)+power(yy.y-25,2)))<4 THEN '#' WHEN > >> (power((xx.x-10),2)/40+power((yy.y-10),2)/40)=1 THEN ' > > > > WHEN (power((xx.x-10),2)/40+power((yy.y-40),2)/40=1) THEN ' ELSE ' ' > END),' > > ') as cartoon from > > > > > > (select generate_series(1,40) as x) as xx,(select generate_series(1,50) > as > > y) as yy group by xx.x order by xx.x) as co_ord; > > > > Tem a manha de fazer um melhor? > > > > > http://feedproxy.google.com/~r/blogspot/rFRqt/~3/oTGb8aK0Qt4/cartoon-in-pg.html > > < > http://feedproxy.google.com/%7Er/blogspot/rFRqt/%7E3/oTGb8aK0Qt4/cartoon-in-pg.html > > > > > > Cool! > > []s > > Flavio Gurgel > > _______________________________________________ > > pgbr-geral mailing list > > [email protected] > > https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral > > \o/ > > Bruno E. A. Silva. > Analista de Sistemas. > _______________________________________________ > pgbr-geral mailing list > [email protected] > https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral >
Congratulations
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
