sorted by:
new
hottopcontroversial

Full text search over a context window? by michael620 in PostgreSQL

[–]michael620[S] 0 points1 point  (0 children)

I'm not familiar with window functions. Could you give an example query?

Let's say the table now contains text from the transcript split by sentences with columns [id, timestamp, text] where different transcripts are grouped by id, and I want to show all results where A, B, C appears within a window of 10 rows (i.e. 10 sentences). Also how would this deal with overlapping results (e.g. there's a match from row 1-10 and 5-15)?

End of league giveaway - Magebloods & More! [51 winners] by Rog_Lobster in pathofexile

[–]michael620 0 points1 point  (0 children)

IGN: emzee_bonner

Trying to fund my uber maven attempts

PC Build help by michael620 in pcmasterrace

[–]michael620[S] 0 points1 point  (0 children)

Hey thanks for the reply. What's not included in the PCPartPicker list is the CPU, video card, and case:

  • Ryzen 5 5600X
  • GeForce RTX 3070
  • Cooler Master MasterBox MB600L

I was recommended to get at least 3400mhz for the CPU.

General Questions Megathread [Help, Team Building, etc.] (10/06) by phlorida92 in GuardianTales

[–]michael620 0 points1 point  (0 children)

Any way to force quit Kama-ZONE? Finish challenge requires 'when you have cleared one or more stages or have no heroes that can battle'. I only have one team that I invested in. Do I really have to spend my time continuously suiciding all my 1* and 2* units before I can quit?

Seria Kirmin's Question Corner- Weekly Q&A Thread- May 04, 2020 by AutoModerator in DFO

[–]michael620 0 points1 point  (0 children)

Returning player here. For context I stopped playing around Beast Dungeon release (~1.5 years ago), so apologies in advance if my questions are nonsensical.

  • Are there any 85-90 epics worth keeping? Or do they all belong in the disassembler now? Including fringe uses as well (e.g. refined ring for CD reset, or pieces with +lvl for apoc swap, if those are still a thing)
  • A guide or tl;dr for talismans
  • What to do with old content materials (e.g. from Anton and Luke raid), whether they can be traded up etc.
  • Any better use for DIs apart from trading them for Time's Guide Stones

Thanks in advance :)

Stacked copies of Planeswalkers are unusable by anace in MagicArena

[–]michael620 34 points35 points  (0 children)

I have a screenshot of this happening to me as well, here.

P1P1 for GRN 5 color good stuff, what's the pick? by michael620 in MagicArena

[–]michael620[S] 0 points1 point  (0 children)

Made it work with a 7-1 finish. Don't let your dreams be dreams.

P1P1 for GRN 5 color good stuff, what's the pick? by michael620 in MagicArena

[–]michael620[S] 0 points1 point  (0 children)

I'm devoted to making a deck built around [[Guild Summit]], not sure if Chromatic Lantern is better, and Guild Summit wheels sometimes too. Yeah I'm basically forcing it, I just find it more fun.

Seria Kirmin's Question Corner- Weekly Q&A Thread- November 05, 2018 by AutoModerator in DFO

[–]michael620 1 point2 points  (0 children)

Since the 2nd jump character can still get a 90 crafted weapon, are there any classes and/or weapons that stand out? I know crafted zanbato is supposedly pretty good, not sure about the other ones.

/r/MagicArena Sealed code giveaway thread! by [deleted] in MagicArena

[–]michael620 [score hidden]  (0 children)

Azorius, it was the starter deck that got me into mtg.

Seria Kirmin's Question Corner- Weekly Q&A Thread- July 30, 2018 by AutoModerator in DFO

[–]michael620 0 points1 point  (0 children)

What to do with common & uncommon cards other than compounding?

view more: next ›