[INSERT]Insert blank values

From: Leví Teodoro da Silva <tlevisilva(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: [INSERT]Insert blank values
Date: 2008-10-24 11:59:12
Message-ID: 4a74ba520810240459r5ab6513j4deeccac11a3c3dd@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Leví Teodoro da Silva 2008-10-24 12:04:28 Re: [INSERT]Insert blank values
Previous Message Damian Carey 2008-10-23 20:38:53 Re: Simple Text Field Encryption