[INSERT]Insert blank values
От
Leví Teodoro da Silva
Тема
[INSERT]Insert blank values
Дата
Msg-id
4a74ba520810240459r5ab6513j4deeccac11a3c3dd@mail.gmail.com
Список
Дерево обсуждения
[INSERT]Insert blank values "Leví Teodoro da Silva" <tlevisilva@gmail.com>
Re: [INSERT]Insert blank values "Leví Teodoro da Silva" <tlevisilva@gmail.com>
Hi guys,
I have a little problem.
I want to insert a blank on a varchar field. When i do the follow :
INSERT INTO "Seller"("name", "id")VALUES ( null ,'1'); it works perfectly !!!
But if i try :
INSERT INTO "Seller"("name", "id")VALUES ( '','1'); The postgres insert in my database the value '', and i dont want it.
The first way, is the only way for insert blank values !? Because it is not good for me, because i received a lot of fields from a form and i don't want to put null if the value is blank, and don't if it is not blank.
Regards,
Levi
I have a little problem.
I want to insert a blank on a varchar field. When i do the follow :
INSERT INTO "Seller"("name", "id")VALUES ( null ,'1'); it works perfectly !!!
But if i try :
INSERT INTO "Seller"("name", "id")VALUES ( '','1'); The postgres insert in my database the value '', and i dont want it.
The first way, is the only way for insert blank values !? Because it is not good for me, because i received a lot of fields from a form and i don't want to put null if the value is blank, and don't if it is not blank.
Regards,
Levi
В списке pgsql-novice по дате отправления
