Help with prepared statement

From: Bendik Rognlien Johansen <bendik(dot)johansen(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Help with prepared statement
Date: 2005-05-23 15:51:04
Message-ID: C000E196-F222-4383-B72F-5AC7BA089E1E@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hello,
I am having some difficulty using a prepared statement.

PREPARE fooplan(int4, int4) AS SELECT * FROM records WHERE id = $1
AND fax = $2;

Normally this works fine like this:
EXECUTE fooplan(42985, 12345678);

However, sometimes I need to match NULL values like this:

EXECUTE fooplan(42985, NULL);

This fails of course since "fax = NULL" is not the same as "fax IS
NULL".

Is there any way around this?

Thanks!

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Bruno Wolff III 2005-05-23 17:52:16 Re: Problem restarting server
Previous Message Agustín Caminero Herráez 2005-05-23 14:20:23 Re: Problem restarting server