Fantastico, era isso mesmo. Obrigado! Eloi Ribeiro GIS Analyst 39,45º -4,40º http://eloiribeiro.wordpress.com
2011/3/8 Tiago Adami <[email protected]> > Em 8 de março de 2011 12:50, Eloi Ribeiro <[email protected]> > 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 > [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
