Postgres Pro
Downloads
Home   >   mailing lists

Re: Still unclear about PQexecParams and "create view" - Mailing list pgsql-general

From Tom Lane
Subject Re: Still unclear about PQexecParams and "create view"
Date
Msg-id 19876.1171335148@sss.pgh.pa.us
Whole thread Raw
In response to Still unclear about PQexecParams and "create view"  ("Phil Endecott" <spam_from_postgresql_general@chezphil.org>)
List pgsql-general
Tree view 
"Phil Endecott" <spam_from_postgresql_general@chezphil.org> writes:
> - Can anyone offer a list of which commands are compatible with
> PQexecParams and which aren't?

Plannable queries can take parameters: SELECT/INSERT/UPDATE/DELETE.
Utility commands (which is everything else) don't do any expression
evaluation and thus can't deal with parameters.

> - Is this likely to change any time soon?

No.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: getting postgres to emulate mysql/sqlserver bit datatype
Next
From: Tom Lane
Date:
Subject: Re: Dumb question - how to tell if autovacuum is doing its job in 8.2.x