Seems that

SELECT COUNT(*) FROM "events" INNER JOIN "events" "events_2"  WHERE
("events"."schedule_id" = 1 AND "events"."start_at" = "events_2"."start_at"
AND "events_2"."schedule_id" IN (3));

is bad but this is ok

SELECT COUNT(*) FROM "events" INNER JOIN "events" "events_2"  ON
("events"."schedule_id" = 1 AND "events"."start_at" = "events_2"."start_at"
AND "events_2"."schedule_id" IN (3));

Perhaps in postgres using a JOIN always requires an ON clause though in
MySQL this is not always the case.

Any ideas?

B

-- 
You received this message because you are subscribed to the Google Groups "Ruby 
on Rails: Talk" 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-talk?hl=en.

Reply via email to