[MonetDB-users] Persistent Stored Modules 'OR' operator

17 Apr 2007


      Is the OR operator supported in a persistent stored
module?

e.g.
---------------------
create function tmp_myfunction(a integer)
returns table (val integer)
begin
    if a < 1 or a > 100 then
        return table (
           select val from mytable
        );
    else
        return table (
           select val from another_table
        );
    end if;
end;
---------------------

will return the error:
ERROR = !SELECT: no such binary operator 'or(int,int)'

Colin Foss

Niels Nes

tags

participants (2)