| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | Ryan Williams <shrewsbury(at)louisiana(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: FW: Count & Distinct |
| Date: | 2000-08-24 18:06:45 |
| Message-ID: | Pine.BSF.4.10.10008241059320.32697-100000@megazone23.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Yeah,
There is no column 'row'. You're trying to use 'row' as
the value expression. Postgres figures it's a column
reference and tries to find it (and doesn't).
<general set function> ::=
<set function type>
<left paren> [<set quantifier>] <value expression> <right paren>
Set function type is COUNT, set quantifier is DISTINCT,
'row' is not a valid value expression in this case.
Note also, if I'm reading the spec right, * is not
valid in this context either.
On Thu, 24 Aug 2000, Ryan Williams wrote:
> I'm running 7.0.2 (or at least I believe so). Is there something that /I/
> may be doing wrong?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joel Burton | 2000-08-24 18:10:04 | Re: Problem with rules & ODBC |
| Previous Message | J. Atwood | 2000-08-24 17:58:28 | Re: Count & Distinct |