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?