Thread: PGS 7.4.x PREPARE statement

Hi,

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") ?

Geoffrey Kretz
Four J's Development Tools

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