Not surprising

IWETHEY v. 0.3.0 | TODO

1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User

Welcome to IWETHEY!

Post #258,189 by drewk 6/8/06 2:42:46 PM Reply	Not surprising I haven't used Postgres in anger for a couple of years. I'm sure there's a lot of MySQL-isms that I incorrectly attribute to Postgres. As for getting the wrong values back when using this technique in MySQL: either I got very lucky very often, or I used to know a way to make sure you got the right thing back, which I have since forgotten. === Purveyor of Doc Hope's [link\|http://DocHope.com\|fresh-baked dog biscuits and pet treats]. [link\|http://DocHope.com\|http://DocHope.com]
Post #258,191 by ben_tilly 6/8/06 2:50:14 PM Reply	Or you didn't double-check enough Logic errors are the hardest kind of bugs to find. Depending on the implementation, if you were trying it in an example like the above on a table that had been filled in sequentially, it might frequently pick the minimum row. So it would look like it was doing something, even when it wasn't. Cheers, Ben I have come to believe that idealism without discipline is a quick road to disaster, while discipline without idealism is pointless. -- Aaron Ward (my brother)
Post #258,205 by drewk 6/8/06 4:17:32 PM Reply	Also possible Though it was long enough ago that I can't even remember a representative example. I'll chalk that up as "something I may have gotten away with". It wouldn't be the only thing. === Purveyor of Doc Hope's [link\|http://DocHope.com\|fresh-baked dog biscuits and pet treats]. [link\|http://DocHope.com\|http://DocHope.com]

Left Outer Join question - (ChrisR) - (20) - June 7, 2006, 10:26:29 PM EDT

One approach - (ben_tilly) - (6) - June 8, 2006, 01:13:51 PM EDT

Some variation on MIN... - (ChrisR) - (3) - June 8, 2006, 11:10:15 AM EDT

It probably will not optimize - (ben_tilly) - (2) - June 8, 2006, 01:27:27 PM EDT

Yep, took forever to run. - (ChrisR) - (1) - June 8, 2006, 02:00:51 PM EDT

Nothing non-standard about that - (drewk) - June 8, 2006, 02:40:14 PM EDT

Pre indentation - (ChrisR) - (1) - June 8, 2006, 02:02:57 PM EDT

Bug, indentation can be lost during edits (new thread) - (ben_tilly) - June 8, 2006, 02:18:49 PM EDT

Does SQL Server support "DISTINCT ON"? - (drewk) - (12) - June 8, 2006, 08:55:49 AM EDT

That is really what I need! - (ChrisR) - June 8, 2006, 10:56:50 AM EDT

The more readable version is invalid (at least in Oracle) - (ben_tilly) - (10) - June 8, 2006, 01:12:25 PM EDT

Hmm, both Postgres and MySQL support the same non-standard? - (drewk) - (9) - June 8, 2006, 01:49:01 PM EDT

Can you please help me find mine? - (folkert) - June 8, 2006, 02:04:49 PM EDT

That is a MySQL shortcut - (ben_tilly) - (7) - June 8, 2006, 02:14:38 PM EDT

Not surprising - (drewk) - (2) - June 8, 2006, 02:42:46 PM EDT

Or you didn't double-check enough - (ben_tilly) - (1) - June 8, 2006, 02:50:14 PM EDT

Also possible - (drewk) - June 8, 2006, 04:17:32 PM EDT

I've encountered that problem. - (static) - (3) - June 8, 2006, 08:48:27 PM EDT

Justifiable arrogance in many cases - (ben_tilly) - (2) - June 8, 2006, 09:18:47 PM EDT

Oh I have little doubt about that. - (static) - (1) - June 8, 2006, 09:35:59 PM EDT

Oracle is picky but... - (ben_tilly) - June 8, 2006, 10:03:53 PM EDT

If the people speak and the king doesn't listen, there is something wrong with the king. If the king acts precipitously and the people say nothing, something is wrong with the people.
134 ms