From: Michael A. Mayo <mmayo@mcauleybrooklyn.org>
To: Rudolph, Michael <Michael.Rudolph@telekom.de>
To: 'Alessio Bragadini' <alessio@albourne.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: What is the difference between NULL and "undef"
Date: Tue, 16 May 2000 13:18:46 -0400
Message-ID: <001001bfbf5a$cde10020$2182b798@362197428> (raw)
References: <EB8366869DABD2119F3200A0C9F02CC8016544E0@U8P27>
---- Original Message -----
From: "Rudolph, Michael" <Michael.Rudolph@telekom.de>
> I do that statement from Perl via DBI without placeholders.
> According to the DBI-Documentation, it should be possible:
> "Undefined values or undef can be used to indicate null values",
> this sentence is an excerpt from the doc. My application reads in
> input text-fields from a web-formular, so do I always have to
> do a check, if the field is empty and than put it explicit to NULL?
I believe you are confused about the meaning of "undef." In general,
variables are classified as undefined in one of 2 ways:
1) The variable is not declared, or is declared but no value is ever
assigned to it
2) The variable is assigned the return value of some function, and the
function fails, returning undef.
A valid value is not "undef." Things like empty string or the number 0 are
valid values for a variable to have, and therefore are not "undef." Undef
should be interpreted as "something is catastrophically wrong with this
variable."
CGI.pm returns an empty string for text form fields that are not filled out.
Therefore, it is neccecary to test for the empty string and translate that
to
NULL or undef if you want an empty form field to work out to NULL.
----------------------------------------------------------------------------
On my system, the following mini-program inserts a NULL value:
my $test_string; #note: no value assigned to test_string - it's undefined
my $database = DBI->connect("dbi:Pg:dbname=test");
$test_string = $database->quote($test_string);
$database->do("
INSERT INTO employees(name)
VALUES($test_string)
");
----------------------------------------------------------------------------
The following mini-program inserts an empty string:
my $test_string = ""; #empty string assigned to test_string
my $database = DBI->connect("dbi:Pg:dbname=test");
$test_string = $database->quote($test_string);
$sql_statement = $database->do("
INSERT INTO employees(name)
VALUES($test_string)
");
-Mike
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: mmayo@mcauleybrooklyn.org, Michael.Rudolph@telekom.de, alessio@albourne.com
Subject: Re: What is the difference between NULL and "undef"
In-Reply-To: <001001bfbf5a$cde10020$2182b798@362197428>
References: <EB8366869DABD2119F3200A0C9F02CC8016544E0@U8P27> <001001bfbf5a$cde10020$2182b798@362197428>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox