Thread: Default and PQexecParams

Default and PQexecParams

From
Jerry LeVan
Date:
Hi,

How could one differentiate between DEFAULT and 'DEFAULT' as parameters
to PQexecuteParams?

Jerry

Re: Default and PQexecParams

From
ljb
Date:
jerry.levan@eku.edu wrote:
> Hi,
>
> How could one differentiate between DEFAULT and 'DEFAULT' as parameters
> to PQexecuteParams?

I assume you mean the libpq function PQexecParams(), and you want to use a
parameterized query for INSERT or UPDATE.

I don't think it is possible to use DEFAULT because it is a keyword,
and only a value expression will work as a parameter.

With NULL vs 'NULL', PQexecParams() has a special case to handle NULL
(null pointer in the paramValues array).