pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  

help / color / mirror / Atom feed

Set NULL Using PQexecParams
2+ messages / 2 participants
[nested] [flat]

* Set NULL Using PQexecParams
@ 2006-11-23 18:11  Keary Suska <hierophant@pcisys.net>
  0 siblings, 1 reply; 2+ messages in thread

From: Keary Suska @ 2006-11-23 18:11 UTC (permalink / raw)
  To: 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"





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Set NULL Using PQexecParams
@ 2006-11-23 19:01  Volkan YAZICI <yazicivo@ttnet.net.tr>
  parent: Keary Suska <hierophant@pcisys.net>
  0 siblings, 0 replies; 2+ messages in thread

From: Volkan YAZICI @ 2006-11-23 19:01 UTC (permalink / raw)
  To: Keary Suska <hierophant@pcisys.net>; +Cc: 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.



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2006-11-23 19:01 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-11-23 18:11 Set NULL Using PQexecParams Keary Suska <hierophant@pcisys.net>
2006-11-23 19:01 ` Volkan YAZICI <yazicivo@ttnet.net.tr>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox