Em 8 de março de 2011 12:50, Eloi Ribeiro <eloi.ribe...@gmail.com> escreveu: > 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, >
Primeiro você precisa definir qual o valor irá substituir os nulos. Se for usar a hora zero ( 00:00:00 ), tente a função COALESCE para cada uma das colunas: SELECT COALESCE(c0,'00:00:00')-(COALESCE(c1,'00:00:00')+COALESCE(c2,'00:00:00')+COALESCE(c3,'00:00:00')+COALESCE(c4,'00:00:00')) FROM t1; -- TIAGO J. ADAMI http://www.adamiworks.com _______________________________________________ pgbr-geral mailing list pgbr-geral@listas.postgresql.org.br https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
