Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Counting propositions

Re: Counting propositions

From: Mikito Harakiri <mikharakiri_at_iahu.com>
Date: Mon, 14 Jun 2004 10:57:40 -0700
Message-ID: <GRlzc.26$kd5.79@news.oracle.com>

"Laconic2" <laconic2_at_comcast.net> wrote in message news:RYKdnQ02bsxjNFDdRVn-vg_at_comcast.com...
>
> "x" <x-false_at_yahoo.com> wrote in message news:40cd9b6a_at_post.usenet.com...
>
> > If tuples in a relational relation(ship) (or relvar) are propositions,
> what
> > is the meaning of :
> >
> > select count(distinct *) as nr
> > from <relvar>
> >
> > and the like ?
>
> Before dealing with your question, we have to decode the intent behind
the
> wildcard.
>
> In particular, when does the wildcard get expanded to the list of all the
> columns? At compile time? at execution time?
>
> It makes a difference.

Why does it make a difference? Exotic operators aside (e.g. Pivot by Microsoft), could you give an example, simple select-project-join preferrably? Received on Mon Jun 14 2004 - 12:57:40 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US