[MonetDB-users] Persistent Stored Modules 'OR' operator
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)'
On Tue, Apr 17, 2007 at 12:39:09PM -0700, Colin Foss wrote:
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)'
This problem has been fixed. Maybe you could try the recent version of the stable or development branches.
Niels
This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
participants (2)
-
Colin Foss
-
Niels Nes