[GENERAL] Embarassing GROUP question

2009-10-03 Thread Corey Tisdale
Hi all, I'm a recent MySQL convert, and I am having some difficulty with syntax on grouping a table by a foreign key and returning only the newest entry that matches. In MySQL, you can do something like event_log id event_type event_date meaningful_data SELECT meaning

Re: [GENERAL] Embarassing GROUP question

2009-10-03 Thread Corey Tisdale
res. I didn't mean for my comparison to appearas a knock against postgres, merely to explain why I was having such a problem with such a simple issue. Thanks again for the help. Corey Tisdale On Oct 3, 2009, at 3:39 PM, Tom Lane wrote: Sam Mason writes: On Sat, Oct 03, 2009 at 01:05:49

Re: [GENERAL] Embarassing GROUP question

2009-10-03 Thread Corey Tisdale
ned ints before shifting. Postgres appears to not do this at all, or our arbitrarily large test data did not trigger it on postgres. After the last few days, it is becoming apparent how much of a joke mysql has been. Thanks again for such quick direction! Corey Tisdale On Oct 3, 2009,