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 > [email protected] > https://lists.sourceforge.net/lists/listinfo/monetdb-users -- Niels Nes, Centre for Mathematics and Computer Science (CWI) Kruislaan 413, 1098 SJ Amsterdam, The Netherlands room C0.02, phone ++31 20 592-4098, fax ++31 20 592-4312 url: http://www.cwi.nl/~niels e-mail: [EMAIL PROTECTED] ------------------------------------------------------------------------- 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 [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-users
