Re: [INSERT]Insert blank values - Mailing list pgsql-novice

From Leví Teodoro da Silva
Subject Re: [INSERT]Insert blank values
Date
Msg-id 4a74ba520810240504v61e2feffr500abbd45a7f3f91@mail.gmail.com
Whole thread Raw
In response to [INSERT]Insert blank values  ("Leví Teodoro da Silva" <tlevisilva@gmail.com>)
List pgsql-novice
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í

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


pgsql-novice by date:

Previous
From: "Leví Teodoro da Silva"
Date:
Subject: [INSERT]Insert blank values
Next
From: "Oliveiros Cristina"
Date:
Subject: Re: [INSERT]Insert blank values