Alegrou a minha tarde, heheheh!
Cordialmente,
Cláudio Leopoldino
postgresqlbr.blogspot.com/
=================================================
Em Quarta-feira, 2 de Abril de 2014 13:37, Flavio Henrique Araque Gurgel
<[email protected]> escreveu:
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
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
