search

kputnam / piggly

PL/pgSQL stored procedure code coverage tool
Other
70 stars 14 forks source link

Assignment statement issue #8

Closed lcoldiron closed 13 years ago

lcoldiron commented 13 years ago

x TEXT :=E'\002schema\003';

Appears there needs to be a space after the := for the parser to handle this, however Postgres does not require it.

lcoldiron commented 13 years ago

Here is a better example:

CREATE OR REPLACE FUNCTION my_schema.my_func() RETURNS VOID AS $BODY$ DECLARE my_schema_var TEXT:=E'\002my_schema\003'; BEGIN END; $BODY$ LANGUAGE plpgsql STABLE STRICT;

This is broken: my_schema_var TEXT:=E'\002my_schema\003';

This will work my_schema_var TEXT :=E'\002my_schema\003';

Pretty easy to work around this issue by adding the space but that pesky Postgres allows this syntax.