RE: boolean functions?

"Zabach, Elke" <[email protected]> Mon, 18 Aug 2003 12:00:49 +0200

Newsgroups	gmane.comp.db.sapdb.general
Message-ID	<[email protected]>

Sven KÃ¶hler wrote:

> hi,
> 
> it's just a style question, but since
>    SELECT a OR b FROM table
> doesn't work, i had to find out that i can use
>    SELECT GREATEST(a, b) FROM table
> instead.
> 
> GREATEST sees to behave like OR, and LEAST seems to behave 
> like AND, but 
> this is only due the fact, that true seems to be "greater" than false.
> 
> Is there any better way instead using GREATEST?

As MaxDB does not support AND/OR in the select-list, this seems
to be the shortest (and 'best') way.

Elke
SAP Labs Berlin