Thread: Set NULL Using PQexecParams

Set NULL Using PQexecParams

From
Keary Suska
Date:
Is it possible to set a NULL value as a parameter value to PQexecParams?
I.e., other than hard-coding it into the command string.

The idea is mostly for UPDATE statements, so a column could be set to null
if it otherwise does not have a valid value.

Thanks,

Keary Suska
Esoteritech, Inc.
"Demystifying technology for your home or business"




Re: Set NULL Using PQexecParams

From
Volkan YAZICI
Date:
On Nov 23 11:11, Keary Suska wrote:
> Is it possible to set a NULL value as a parameter value to PQexecParams?
> I.e., other than hard-coding it into the command string.

"paramValues[] specifies the actual values of the parameters. A null
pointer in this array means the corresponding parameter is null; ..."
says the documentation.


Regards.