Date: Wed, 21 Aug 2013 17:06:26 -0400 (EDT)
From: Max Pyziur <pyz@brama.com>
To: pgsql-interfaces@postgresql.org
Subject: binding a variable to NULL in perl-DBD
Message-ID: <alpine.LRH.2.03.1308211655440.1058@brama.com>
User-Agent: Alpine 2.03 (LRH 1266 2009-07-14)
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; format=flowed; charset=US-ASCII
Precedence: bulk
Sender: pgsql-interfaces-owner@postgresql.org


Greetings,

I'm trying to determine how to pass "NULL" to a variable, specifically in 
the conditional section of a SQL statement:

SELECT moo
FROM foo aa
WHERE field1 = ?
AND field2 = ?

Sometimes at the command line, when running the perl-DBD script, I would 
like the select statement to reflect:

SELECT moo
FROM foo aa
WHERE field1 = 'goo'
AND field2 IS NULL

Much thanks in advance,

Max Pyziur
pyz@brama.com


-- 
Sent via pgsql-interfaces mailing list (pgsql-interfaces@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-interfaces