[raster] ST_AsTiff syntax error

[strk]

rtpostgis.sql:1132: ERROR:  "$1" is declared CONSTANT
CONTEXT:  compilation of PL/pgSQL function "st_astiff" near line 2

PostgreSQL 8.4.3 on x86_64-pc-linux-gnu, compiled by GCC gcc-4.4.real (Ubuntu 4.4.3-4ubuntu5) 4.4.3, 64-bit

This is as of r7160

[dustymugs]

Can you try r7170? The problem boiled down to modifying a function parameter in plpgsql. PostgreSQL 9.0 permits it while 8.4 does not.

[strk]

With r7170:

psql:/home/src/postgis/postgis/regress/../raster/test/regress/rtpostgis.sql:1229: ERROR:  syntax error at or near "RETURN"
LINE 3:  AS $$ RETURN st_astiff(st_band($1, $2), $3, NULL::text[], s...

[strk]

if it's an SQL function you would use SELECT instead of RETURN

[dustymugs]

Oops. Somehow that got by me. That and one more fixup in r7171.

[strk]

r7171 does fix the syntax error, thanks