Re: deallocating prepared statements
"Daniel Verite" <[email protected]> Wed, 03 Dec 2008 22:01:02 +0100
| Newsgroups | gmane.comp.db.postgresql.interfaces |
|---|---|
| Message-ID | <e31a904f-4056-481d-9990-5f153bc59853@mm> |
Haszlakiewicz, Eric wrote: > >The prepared statement's name is not a literal, and in general > >parameterized queries don't accept parameters beyond literals. So you > >need to insert the name directly into the SQL command text. > > > > Well, that sucks. Now I need to worry about quoting and escaping. :( > Is there a limit of what characters can be used in statement names? > Neither the docs for PQprepare(), nor the docs for the prepare statement > say anything about that. I think the statement's name is an "identifier", just like a table or column name. So it has to follow the rules defined for identifiers in the "SQL syntax" chapter. Best regards, -- Daniel PostgreSQL-powered mail user agent and storage: http://www.manitou-mail.org -- Sent via pgsql-interfaces mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-interfaces