Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
_a_a_a_
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
32 ms
·
421.
▲
by
_a_a_a_
3y ago
"Safe to say the Vikings social media team is going to be thinking long and hard..." those last 3 words genuinely accidental?
422.
▲
by
_a_a_a_
3y ago
I think the title should be qualified as 'edible fruit' because that's what this seems to be about, not any old fruit botanically speaking
423.
▲
by
_a_a_a_
3y ago
It's an interesting read and an interesting perspective but he's arguing from a very absolutist position. "but I have previously argued that it is wrong to fire homophobes and racists..." But if you've got homophobe
424.
▲
by
_a_a_a_
3y ago
Because it says 'clearly'. (but yeah, agree with you)
425.
▲
by
_a_a_a_
3y ago
It would be helpful if you could put a small, indeed minimal, example of tree SQL on that page, including the schema for data and some idea of the syntax, especially showing where the recursion happens (if it happens). The query currently t
426.
▲
by
_a_a_a_
3y ago
In MS SQL they are used together although I don't know if this is the standard. eg. SELECT city, STRING_AGG(email,';') WITHIN GROUP (ORDER BY email) email_list FROM sales.custo
427.
▲
by
_a_a_a_
3y ago
> using Lotus Notes / 1-2-3 on a single-core IBM 5150 with 5 MHZ and 256KB of memory That was a ridiculous interpretation of what I asked so how about not strawmanning people asking questions. And BTW I gave you the spec of my curre
428.
▲
by
_a_a_a_
3y ago
Umm, isn't htat what 'over' is for? From memory (prob wrong but close enough) select string_concat(name) over (order by name) from ...
429.
▲
by
_a_a_a_
3y ago
I'm not sure if this is a stupid attempt at a rebuttal, or if you've accidentally made a rather good point as well. BTW My home machine is a decade-old dual core and it runs email, web and all of Libreofffice just fine, and with 9
430.
▲
by
_a_a_a_
3y ago
I said biz not dev
431.
▲
by
_a_a_a_
3y ago
> but the device failed to win us over in terms of multi-core performance If a dev machine I'd get it, but biz users are email and a few small spreadsheets. I don't get why biz users need multicore anything.
432.
▲
by
_a_a_a_
3y ago
For the scutters... err, hang on...
433.
▲
by
_a_a_a_
3y ago
Barbara Bain (playing Helena Russell in Space 1999) married Martin Landau (captain(?) Koenig in same). They had a daughter Juliet Landau who played - IMO played rather well - Drusilla in Buffy, the vampire who was about fifteen sandwiches a
434.
▲
by
_a_a_a_
3y ago
>> AIUI it's an absence or deficiency of theory of mind > I'm not sure what that means. I find it very odd that you debate autism but don't know this. https://www.spectrumnews.org/wiki/theory-of-
435.
▲
by
_a_a_a_
3y ago
Honestly, that sounds slightly questionable. AIUI it's an absence or deficiency of theory of mind. It's something you haven't - it's a lack, like deafness. As to whether it's an illness or not, I suppose it'
436.
▲
by
_a_a_a_
3y ago
Your cynicism runs through you like your skeleton but I don't share it.
437.
▲
by
_a_a_a_
3y ago
Exactly! (except for that I'm pretty certain I don't have autism, though I know I'm not wired like other people)
438.
▲
by
_a_a_a_
3y ago
Pronounce as follows: say "Oh mah gawd" then elide the "gawd".
439.
▲
by
_a_a_a_
3y ago
Cynical indeed given your quoted phrase doesn't appear in the article. Even the word Underground doesn't AFAICS.
440.
▲
by
_a_a_a_
3y ago
Word. BTDT, all services getting out of sync etc. Not worth it.
441.
▲
by
_a_a_a_
3y ago
It's 'related' in that it's exactly the same course given in the link, specifically [10] at the end, thanks.
442.
▲
by
_a_a_a_
3y ago
It's the kind of thing that might make sense if you understood it, but that's hardly going to help a newbie. I also have some real doubt whether it's actually accurate or helpful. For instance "If an execution is represe
443.
▲
by
_a_a_a_
3y ago
Without JS this site's text is a weird mix of upper and lower case letters, even within the same word. Even large lowercase mixed in. The underlying text is perfectly normal. Can any web devs suggest why this is? TIA
444.
▲
by
_a_a_a_
3y ago
You most definitely should be able to do that, and the SQL standard provides for this (sort of, kind of): TABLESAMPLE. This applies specifically to exactly one table so the issue of dubious predicate pushdown never arises. That said, I unde
445.
▲
by
_a_a_a_
3y ago
I'm an idiot sorry about that. Okay, let's try again, suppose you wrote SELECT * FROM t1 WHERE 2+2=4 Which is semantically identical to SELECT * FROM t1 While the first is correct in that it has a semantic meaning and a valid outp
446.
▲
by
_a_a_a_
3y ago
You are completely correct, but please see below where I acknowledge that half the problem is that a nondeterministic input - the rand() - is the other half. Hopefully by banning nondeterministic functions in predicates, then requiring pred
447.
▲
by
_a_a_a_
3y ago
It depends. For what you're suggesting, we have the cross join/cartesian join. That would be the correct thing to use in this case, not what you've put. But actually you have a point in that half the problem is the predicate
448.
▲
by
_a_a_a_
3y ago
> Most people know 1000 words on average in English Maybe I misunderstand but that sounds so stupid and wrong I don't know where to start. Standard vocab estimates are 15K - 30K, averaging about 20K (these from memory) Edit: from wi
449.
▲
by
_a_a_a_
3y ago
Interesting investigation. I'd argue that the SQL query itself is wrong in that the predicate is in no way related to the tables so the entire thing should be rejected.
450.
▲
by
_a_a_a_
3y ago
Texas & wetland in the same sentence??? Perhaps someone can expound cos I'm a brit. Thanks
More ›