Hello !
There is a strange behaviour in the SQL function parser (haven't tested this with the plpgsql lang) when using standard operators
and function parameters.
Take the following for example:
create or replace function testfunc1(int) returns setof test as
'
select * from test where age>$1;
'
language sql;
This yealds the following error, which frankly is kind of too much :
ERROR: Unable to identify an operator '>$' for types 'integer' and 'integer'
I strongly belive the parser is a bit keen on interpreting the >$ sequence as an operator. Take for instance php, where all variables start with $; " 100>$foo "
is quite valid !
The error goes away of course when rewriting it as " age > $1".
I'm afraid that taking whitespace into consideration when parsing a language is not the way to do it, except when it's python, of course :)
Hope this, helps,
Regards,
=====
Radu-Adrian Popescu
CSA, DBA, Developer
Aldratech Ltd.