Re: SQL function parse error ? - Mailing list pgsql-sql

Radu-Adrian Popescu wrote:

>
> Take the following for example:
> create or replace function testfunc1(int) returns setof test as
> '
>     select * from test where age>$1;
> '                            ^^^^^^
> language sql;

I didn't find it in documentation, but sql functions are like bash (you 
forgot about space character):

create or replace function testfunc1(int) returns setof test as
'    select * from test where age > $1;
'
works fine.
Postgresql thinks that >$ is an operator instead of >

Tomasz Myrta