Re: Definition please....

Pardon the contradition, but a *proposition* is a statement that is either true or false; a *predicate* is a true proposition.

Regards,

Daniel Guntermann

"Morten" <morten_at_kikobu.com> wrote in message news:3CA1AA26.60205_at_kikobu.com...
> Tundra wrote:
> > When refering to SQL statements what would a predicate be and would
> > the Distinct keyword be considered a predicate?
>
> A predicate is something that evaluates to either true or false.
> DISTINCT is a keyword. The predicates of your query are those
> that narrow down the result relation, they're mostly part of the
> WHERE clause. Eg:
>
> --No predicates
> SELECT id FROM table;
>
> --A single predicate that evaluates to true/false and allows
> --the row conditions that evaluate to true.
> SELECT id FROM table
> WHERE id > 100;
>
> Morten
>
Received on Thu Mar 28 2002 - 05:57:59 CET