Re: deallocating prepared statements
От | Daniel Verite |
---|---|
Тема | Re: deallocating prepared statements |
Дата | |
Msg-id | e31a904f-4056-481d-9990-5f153bc59853@mm обсуждение исходный текст |
Ответ на | Re: deallocating prepared statements ("Haszlakiewicz, Eric" <EHASZLA@transunion.com>) |
Ответы |
Re: deallocating prepared statements
|
Список | pgsql-interfaces |
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, -- DanielPostgreSQL-powered mail user agent and storage: http://www.manitou-mail.org
В списке pgsql-interfaces по дате отправления: