binding a variable to NULL in perl-DBD - Mailing list pgsql-interfaces

From Max Pyziur
Subject binding a variable to NULL in perl-DBD
Date
Msg-id alpine.LRH.2.03.1308211655440.1058@brama.com
Whole thread Raw
Responses Re: binding a variable to NULL in perl-DBD
List pgsql-interfaces
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




pgsql-interfaces by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Issue in Postgre Driver Installation
Next
From: "Daniel Verite"
Date:
Subject: Re: binding a variable to NULL in perl-DBD