PGS 7.4.x PREPARE statement

Geoffrey KRETZ <gk@4js.com> writes:

I was wondering when a PREPARE statement is check. (ie : is it normal
that the following statement doesn't return an error : PREPARE stmnt AS
"xxxxxxxxxxxxxxxx") ?

Hm?

regression=# PREPARE stmnt AS "xxxxxxxxxxxxxxxx";
ERROR: syntax error at or near ""xxxxxxxxxxxxxxxx"" at character 19
regression=#

regards, tom lane

Tom Lane wrote:

Geoffrey KRETZ <gk@4js.com> writes:

I was wondering when a PREPARE statement is check. (ie : is it normal
that the following statement doesn't return an error : PREPARE stmnt AS
"xxxxxxxxxxxxxxxx") ?

Hm?

regression=# PREPARE stmnt AS "xxxxxxxxxxxxxxxx";
ERROR: syntax error at or near ""xxxxxxxxxxxxxxxx"" at character 19
regression=#

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Thx Tom, I should have done a mistake while testing.

Geoffrey