Re: deallocating prepared statements

>-----Original Message-----
>Daniel Verite
>	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

ah.. yes, that makes sense.  	The syntax for identifiers is relatively
simple
(http://www.postgresql.org/docs/8.2/interactive/sql-syntax-lexical.html#
SQL-SYNTAX-IDENTIFIERS), so I _don't_ need to worry about quoting all
that much, just checking for invalid characters.  That's much easier.
Thanks for the pointer!

eric

-- 
Sent via pgsql-interfaces mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-interfaces