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  ("Haszlakiewicz, Eric" <EHASZLA@transunion.com>)
Список 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 по дате отправления:

Предыдущее
От: "Haszlakiewicz, Eric"
Дата:
Сообщение: Re: deallocating prepared statements
Следующее
От: "Haszlakiewicz, Eric"
Дата:
Сообщение: Re: deallocating prepared statements