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