Re: Default and PQexecParams - Mailing list pgsql-general

From ljb
Subject Re: Default and PQexecParams
Date
Msg-id dmg9p3$28up$1@news.hub.org
Whole thread Raw
In response to Default and PQexecParams  (Jerry LeVan <jerry.levan@eku.edu>)
List pgsql-general
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).

pgsql-general by date:

Previous
From: Steve Crawford
Date:
Subject: Re: Installation trouble
Next
From: Tom Lane
Date:
Subject: Re: Getting "cannot remove lock from HTAB" during VACUUM FULL