Pq nao poe uma simples constraint nor null?
> Onde está > *CONSTRAINT* noticia_materia_ck *CHECK*(materia <> ''), > > coloque > > *CONSTRAINT* noticia_materia_ck *CHECK*(length(materia) > 0), > > Deve resolver. > > BEGIN; *ALTER TABLE* noticia *DROP CONSTRAINT* noticia_materia_ck, *ADD* * > CONSTRAINT* noticia_materia_ck *CHECK*(length(materia) > 0);* COMMIT;* > > 2008/9/12 Leonel Freire <[EMAIL PROTECTED]> > >> Sim, eu mesmo criei. Qual o relacionamento dessa constraint com um >> index? >> >> Leonel Freire >> >> _______________________________________________ >> pgbr-geral mailing list >> [email protected] >> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral >> >> > > > -- > William Leite Araújo > Analista de Banco de Dados - QualiConsult > _______________________________________________ > 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
