News for hackers. Stuff that matters.

A comment on Nondeterministic Functions in MySQL (i.e. Rand) Can Surprise You.

Re:Nondeterministic Functions in MySQL (i.e. Rand) Can Surpr... by wolf550e on Thursday December 06, 2018 @01:38PM (#18620756)
Why do people use "i.e." instead of "e.g."?

EDIT:" For people who think I don't know what they mean, I do. I meant that the author of TFA obviously meant to write "Nondeterministic Functions in MySQL (e.g. Rand)", because the entire article is about all non-deterministic functions and just uses rand as an example.

[ Parent | on HN ]
Re:Nondeterministic Functions in MySQL (i.e. Rand) Can Surpr... by lotyrin on Thursday December 06, 2018 @01:57PM (#18620937)
Why do people use the wrong there/their/they're?

Why do people match salmon colored items with rose ones?

Why do people sing off key?

They aren't themselves sensitive to the difference and don't think about it.

[ Parent | on HN ]
Re:Nondeterministic Functions in MySQL (i.e. Rand) Can Surpr... by thisacctforreal on Thursday December 06, 2018 @02:06PM (#18621024)
"i.e." – for "id est" in latin – means "that is", or "in other words", "in essence".

"e.g." is "exempli gratia" in latin; just meaning "for example".

[ Parent | on HN ]
Re:Nondeterministic Functions in MySQL (i.e. Rand) Can Surpr... by qubex on Thursday December 06, 2018 @02:09PM (#18621047)
Because they mean absolutely different things: ”e.g.” stands for “exempli gratia” (“for example”) while “i.e.” stands for “id est” (”in other words”).
[ Parent | on HN ]
Re:Nondeterministic Functions in MySQL (i.e. Rand) Can Surpr... by optimuspaul on Thursday December 06, 2018 @01:56PM (#18620925)
well in this case they only really talk about the one function so i.e. is not incorrect.
[ Parent | on HN ]
Re:Nondeterministic Functions in MySQL (i.e. Rand) Can Surpr... by paulddraper on Thursday December 06, 2018 @02:17PM (#18621125)
They say "Functions" though.
[ Parent | on HN ]
Re:Nondeterministic Functions in MySQL (i.e. Rand) Can Surpr... by abundant on Thursday December 06, 2018 @03:11PM (#18621668)
Here one would read “that is” as something like “specifically”.
[ Parent | on HN ]
Re:Nondeterministic Functions in MySQL (i.e. Rand) Can Surpr... by Zalastax on Thursday December 06, 2018 @05:38PM (#18623140)
But that's not how one should read "that is". The author should have used "e.g." here, no question. Using "i.e." would imply that there exists only one nondeterministic function in MySQL, which is not the case.
[ Parent | on HN ]
Re:Nondeterministic Functions in MySQL (i.e. Rand) Can Surpr... by paulddraper on Thursday December 06, 2018 @08:06PM (#18624219)
Yeah, or I'd say "namely"
[ Parent | on HN ]