INSERT INTO

Developers Databases
#1

Hi, I have to insert a record into a table, but some fields are not to be valued and Scriptcase reports this error:

Error in entering
ERROR: invalid input syntax for type boolean: “”
INSERT INTO public.fabbricato (id_fabbricato, id_localita, id_stradario, civic, annoacquisizione, annomodifica, descrizionemodifica, id_usooriginale, id_usoattuale, supcoperta, volumelordo, id_tipologia, id_stvertint, id_stvertest, id_isolamento, id_storiz, id_pavimento, id_rivestimento, id_serint, id_serest, id_tipovetro, id_copertura, isoacuint, isoacuest, presenzariscaldamento, id_combustibile, id_potenzacaldaia, fontialternative, impiantoidrico, telephone, ISDN, disabiliporta, disabilipercorsiinterni, disabilipercorsiesterni, id_disabiliscala, valoreiniziale, datavaloreiniziale, valorestima, datavalorestima, id_complesso, bandalarga, description, ato, zto) VALUES (93, 0, 7001,’’,’’, ‘c’,’’, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, null, null, ‘’, 0, 0,’’,’’,’’,’’,’’,’’,’’, 0, 0, nULL, 0, nULL, 143,’’,’ c ‘,’’,’ ')
In this case there are Boolean fields that I do not want to exploit.
The Boolean field is isoacuint.
Can anyone help me?
thanks
Beatrice

#2

Re: INSERT INTO

You can insert a 0 or ‘’ for boolean fields. I believe null is not allowed.

Regards,
Scott.

#3

Re: INSERT INTO

The’'are not accepted, while the value 0 is accepted. But in this case, the field has the value false, while I wish they did not value.
Thanks,
Beatrice

#4

Re: INSERT INTO

I think a boolean field cannot be null … it must be true/false

Best regards
Uwe