| From: | "Daniel Verite" <daniel(at)manitou-mail(dot)org> |
|---|---|
| To: | pgsql-interfaces(at)postgresql(dot)org |
| Subject: | Re: deallocating prepared statements |
| Date: | 2008-12-03 21:01:02 |
| Message-ID: | e31a904f-4056-481d-9990-5f153bc59853@mm |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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,
--
Daniel
PostgreSQL-powered mail user agent and storage:
http://www.manitou-mail.org
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Haszlakiewicz, Eric | 2008-12-03 21:27:47 | Re: deallocating prepared statements |
| Previous Message | Haszlakiewicz, Eric | 2008-12-03 17:45:53 | Re: deallocating prepared statements |