Olá à lista, Como faço para evitar resultados null de esta seleçao:
SELECT c0-(c1+c2+c3+c4) FROM t1; c0;c1;c2;c3;c4 "07:01:13";"";"";"";"" "06:50:22";"";"";"";"" "07:09:11";"";"";"";"" "07:28:58";"00:28:00";"";"";"" "11:19:04";"";"";"";"01:33:00" "08:09:24";"";"";"00:27:46";"" "06:44:13";"";"03:40:36";"";"" "07:01:47";"";"";"";"" "07:06:07";"00:14:00";"";"";"" "07:59:49";"";"";"00:30:16";"" "07:00:38";"";"";"";"" "11:05:59";"";"";"00:35:49";"" "07:05:39";"";"";"";"" "06:50:45";"00:14:00";"";"";"" "07:12:36";"";"";"";"" "07:24:36";"";"";"";"" "10:26:16";"";"";"00:32:46";"" "09:03:10";"";"";"01:50:19";"" "06:56:40";"";"";"";"" "08:06:59";"";"";"00:24:06";"" Gostaria que o resultado de 10:00:00-(01:00:00+null+null+null) = 09:00:00 Obrigado, Eloi Ribeiro GIS Analyst 39,45º -4,40º http://eloiribeiro.wordpress.com
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
