> I'm not sure if it's a sql92 thing but count is documented as:
> Returns a count of the number of non-NULL values of expr in the rows
> retrieved by a SELECT statement. The result is a BIGINT value.
Ah, that's good info!
> SQLServer doesn't do this?
UPDATE [posts] SET [comments_count] = NULL
SELECT COUNT([comments_count])
FROM [posts]
WHERE [id] IS NOT NULL
That does indeed return 0. But that does not mean I am constructing the
correct SQL via the Arel visitor or not :)
- Thanks!
Ken
--
You received this message because you are subscribed to the Google Groups "Ruby
on Rails: Core" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/rubyonrails-core?hl=en.
