Thread: [INSERT]Insert blank values
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
Hi guys,
I see that when i do my SELECT query it returns me the blank value, even when in the database i see the ''.
Thanks,
Leví
I see that when i do my SELECT query it returns me the blank value, even when in the database i see the ''.
Thanks,
Leví
2008/10/24 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
At first glance,
I think it might be easy to send to back-end the first INSERT statement if you get a blank for the form
and the second one if you don't get a blank... With an if statement , for ex
Why can't you do that?
Maybe I am misunderstanding your situation.
Best,
Oliveiros
----- Original Message -----From: Leví Teodoro da SilvaSent: Friday, October 24, 2008 12:59 PMSubject: [NOVICE] [INSERT]Insert blank valuesHi 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