Unable to load image
/h/slackernews House Racist Founder
everyone who/whom 7 legs of love :marseyspider:  2yr ago (text post) 162 thread views #133191

Day 21 AoC: use Z3 b-words

Post code, boast about it.

13
New Old Top Bottom Controversial Random
Jump in the discussion.

No email address required.

View entire discussion

To solve this problem, you can write a PostgreSQL query that uses a recursive common table expression (CTE) to evaluate the math operations and determine the final result for each monkey.

WITH RECURSIVE cte AS (
  SELECT name, value
  FROM (VALUES 
    ('root', 'pppw + sjmn'),
    ('dbpl', '5'),
    ('cczh', 'sllz + lgvd'),
    ('zczc', '2'),
    ('ptdq', 'humn - dvpt'),
    ('dvpt', '3'),
    ('lfqf', '4'),
    ('humn', '5'),
    ('ljgn', '2'),
    ('sjmn', 'drzm * dbpl'),
    ('sllz', '4'),
    ('pppw', 'cczh / lfqf'),
    ('lgvd', 'ljgn * ptdq'),
    ('drzm', 'hmdt - zczc'),
    ('hmdt', '32')
  ) AS t(name, value)
  UNION ALL
  SELECT cte.name, 
    CASE
      WHEN value ~ '^[0-9]+$' THEN value::bbbz:
      WHEN value ~ '^[a-z]+ \+ [a-z]+$' THEN cte_left.value + cte_right.value
      WHEN value ~ '^[a-z]+ - [a-z]+$' THEN cte_left.value - cte_right.value
      WHEN value ~ '^[a-z]+ \* [a-z]+$' THEN cte_left.value * cte_right.value
      WHEN value ~ '^[a-z]+ / [a-z]+$' THEN cte_left.value / cte_right.value
    END
  FROM cte -- schizocel join
  JOIN cte cte_left ON cte.value ~ '^[a-z]+' AND cte.value = cte_left.name
  JOIN cte cte_right ON cte.value ~ '[a-z]+$' AND cte.value = cte_right.name
)
SELECT value FROM cte WHERE name = 'root';

This query uses a recursive CTE to evaluate each monkey's job and determine its result. The base case for the CTE is a SELECT statement that selects the name and value for each monkey from the given input. The recursive part of the CTE then performs a SELECT on the CTE itself, using a CASE statement to evaluate the value for each monkey based on the type of job it has. The query also uses a JOIN to the CTE to look up the values for the monkeys that are used in the math operations. Finally, the query selects the value for the monkey named "root" to get the final result.

@TwoLargeSnakesMating discuss

:#marseyantischizo::#marseyantischizo::#marseyantischizo::#marseyantischizo::#marseyantischizo:

Jump in the discussion.

No email address required.

does this solve part 2?

Jump in the discussion.

No email address required.

:#capysneedboat::#capysneedboat::#capysneedboat:

Jump in the discussion.

No email address required.

is that a no?

Jump in the discussion.

No email address required.

Some people are able to display their intelligence by going on at length on a subject and never actually saying anything. This ability is most common in trades such as politics, public relations, and law. You have impressed me by being able to best them all, while still coming off as an absolute idiot.

Jump in the discussion.

No email address required.

:#chadcopecapy::#chadsneedcapy:

Jump in the discussion.

No email address required.



Now playing: World Map Theme (DKC3).mp3

Top Poster of the Day:
Rad_juju
Current Registered Users: 30,857
sidebar image

tech/science swag. :marscientist:

Effortposts made by SN Chads

Guidelines:

What to Submit

On-Topic: Anything that good slackers would find interesting. That includes more than /g/ memes and slacking off. If you had to reduce it to a sentence, the answer might be: anything that gratifies one's intellectual laziness.

Off-Topic: Most stories about politics, or crime, or sports, unless they're evidence of some interesting new phenomenon. Videos of pratfalls or disasters, or cute animal pictures. If they'd cover it on TV news, it's probably lame.

Help keep this hole healthy by keeping drama and NOT drama balanced. If you see too much drama, post something that isn't dramatic. If there isn't enough drama and this hole has become too boring, POST DRAMA!

In Submissions

Please do things to make titles stand out, like using uppercase or exclamation points, or saying how great an article is. It should be explicit in submitting something that you think it's important.

Please don't submit the original source. If the article is behind a paywall, just post the text. If a video is behind a paywall, post a magnet link. Fuck journos.

Please don't ruin the hole with chudposts. It isn't funny and doesn't belong here. THEY WILL BE MOVED TO /H/CHUDRAMA

If the title includes the name of the site, please leave that in, because our users are too stupid to know the difference between a url and a search query.

If you submit a video or pdf, please don't warn us by appending [video] or [pdf] to the title. That would be r-slurred. We're not using text-based browsers. We know what videos and pdfs are.

Make sure the title contains a gratuitous number or number + adjective. Good clickbait titles are like "Top 10 Ways to do X" or "Don't do these 4 things if you want X"

Otherwise editorialize. Please don't use the original title, unless it is gay or r-slurred, or you're shits all fucked up.

If you're going to post old news (at least 1 year old), please flair it so we can mock you for living under a rock, or don't and we'll mock you anyway.

Please don't post on SN to ask or tell us something. Send it to [email protected] instead.

If your post doesn't get enough traction, try to delete and repost it.

Please don't use SN primarily for promotion. It's ok to post your own stuff occasionally, but the primary use of the site should be for curiosity. If you want to astroturf or advertise, post on news.ycombinator.com instead.

Please solicit upvotes, comments, and submissions. Users are stupid and need to reminded to vote and interact. Thanks for the gold, kind stranger, upvotes to the left.

In Comments

Be snarky. Don't be kind. Have fun banter; don't be a dork. Please don't use big words like "fulminate". Please sneed at the rest of the community.

Comments should get more enlightened and centrist, not less, as a topic gets more divisive.

If disagreeing, please reply to the argument and call them names. "1 + 1 is 2, not 3" can be improved to "1 + 1 is 3, not 2, mathfaggot"

Please respond to the weakest plausible strawman of what someone says, not a stronger one that's harder to make fun of. Assume that they are bad faith actors.

Eschew jailbait. Paedophiles will be thrown in a wood chipper, as pertained by sitewide rules.

Please post shallow dismissals, especially of other people's work. All press is good press.

Please use Slacker News for political or ideological battle. It tramples weak ideologies.

Please comment on whether someone read an article. If you don't read the article, you are a cute twink.

Please pick the most provocative thing in an article or post to complain about in the thread. Don't nitpick stupid crap.

Please don't be an unfunny chud. Nobody cares about your opinion of X Unrelated Topic in Y Unrelated Thread. If you're the type of loser that belongs on /h/chudrama, we may exile you.

Sockpuppet accounts are encouraged, but please don't farm dramakarma.

Please use uppercase for emphasis.

Please post deranged conspiracy theories about astroturfing, shilling, bots, brigading, foreign agents and the like. It degrades discussion and is usually mistaken. If you're worried about abuse, email [email protected] and dang will add you to their spam list.

Please don't complain that a submission is inappropriate. If a story is spam or off-topic, report it and our moderators will probably do nothing about it. Feed egregious comments by replying instead of flagging them like a pussy. Remember: If you flag, you're a cute twink.

Please don't complain about tangential annoyances—things like article or website formats, name collisions, or back-button breakage. That's too boring, even for HN users.

Please seethe about how your posts don't get enough upvotes.

Please don't post comments saying that rdrama is turning into ruqqus. It's a nazi dogwhistle, as old as the hills.

Miscellaneous:

The quality of posts is extremely important to this community. Contributors are encouraged to provide high-quality or funny effortposts and informative or entertaining comments. Please refrain from posting the following:

  • Boring wingcucked nonsense nobody cares about that belongs in chudrama

  • Normie shit everyone already knows about

  • Anything that doesn't gratifify one's intellectual laziness

  • Bimothy-tier posts

  • Anything that the jannies don't like

Jannies reserve the right to exile baby ducks from this hole at any time.

We reserve the right to exile you for whatever reason we want, even for no reason at all! We also reserve the right to change the guidelines at any time, so be sure to read them at least once a month. We also reserve the right to ignore enforcement of the guidelines at the discretion of the janitorial staff. This hole is a janny playground, participation implies enthusiastic consent to being janny abused by unstable alcoholic bullies and loser nerds who have nothing better to do than banning you for any reason or no reason whatsoever.

[[[ To any NSA and FBI agents reading my email: please consider ]]]

[[[ whether defending the US Constitution against all enemies, ]]]

[[[ foreign or domestic, requires you to follow Snowden's example. ]]]

https://i.rdrama.net/images/1663436125937968.webp

BROWSE EFFORTPOSTS SITE GUIDE DIRECTORY Emojis & Art | Info Megathreads HOLES PING GROUPS
/h/slackernews SETTINGS /h/slackernews MODS /h/slackernews LOG /h/slackernews EXILEES /h/slackernews FOLLOWERS /h/slackernews BLOCKERS
Link copied to clipboard
Action successful!
Error, please refresh the page and try again.