Re: [SQL] SQL function parse error ?

[Tomasz Myrta]

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


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]