| Lists: | pgsql-interfaces |
|---|
| From: | Keary Suska <hierophant(at)pcisys(dot)net> |
|---|---|
| To: | Postgres-Interfaces <pgsql-interfaces(at)postgresql(dot)org> |
| Subject: | Set NULL Using PQexecParams |
| Date: | 2006-11-23 18:11:43 |
| Message-ID: | C18B326F.8914%hierophant@pcisys.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-interfaces |
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"
| From: | Volkan YAZICI <yazicivo(at)ttnet(dot)net(dot)tr> |
|---|---|
| To: | Keary Suska <hierophant(at)pcisys(dot)net> |
| Cc: | pgsql-interfaces(at)postgresql(dot)org |
| Subject: | Re: Set NULL Using PQexecParams |
| Date: | 2006-11-23 19:01:51 |
| Message-ID: | 20061123190150.GB1406@alamut |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-interfaces |
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.