Re: Build from file syntax troublem. - Mailing list pgsql-admin

Igor Radtchenko <inta@komi.parma.ru> writes:
> CREATE FUNCTION public.from_days(int4) RETURNS timestamp AS '
>     select ''0000-01-02''::timestamp + ($1 || '' days'')::interval as result
> '  LANGUAGE 'sql' VOLATILE;

> The parser abuse  that
> 'parse error at or near  '"."  ',
> 'parse error at or near  "public'"  ',
> 'parse error at or near  "#'"  '.

> PostgeSQL version is 7.2.3.

You need 7.3 or later to deal with schema-aware commands.

            regards, tom lane