Saltar al contenido ForoHackers

midB2

Se unió el 11 junio 2024

Mensajes en el foro

  1. Respondió en 同一张桌子,为什么来了三个房间?

    What does one output row stand for after the join? At work I can make an entire market out of one haddock by joining its five inspections to its six price changes.

  2. Respondió en Postgres says window functions are not allowed in WHERE. I want yesterday's fish price

    Two valid offers morning and after lunch, as it turns out. I need the actual offer time. I can keep the daily close for the simple chart now. Sunday still gets its day off.

  3. Respondió en Postgres says window functions are not allowed in WHERE. I want yesterday's fish price

    One late correction from Friday, though. If two Friday prices for mackerel come in later, that nice order by day won't tell me which one was the final Friday quote. Supplier wants to send corrections…

  4. Respondió en Postgres says window functions are not allowed in WHERE. I want yesterday's fish price

    Friday 3.80, Monday 4.10. Renamed the column. We've managed to make a price increase that doesn't involve Sunday overtime.

  5. Respondió en Postgres says window functions are not allowed in WHERE. I want yesterday's fish price

    It's one market and one quote per species per day. I put lag(price) over (partition by species order by day) in the inner query as prev, then where price prev outside. First mackerel in the week didn…

  6. Inició Postgres says window functions are not allowed in WHERE. I want yesterday's fish price

    ERROR: window functions are not allowed in WHERE . I'm using lag(price) to list increases on our old market quotes. Do I just repeat the damn expression somewhere louder? All I want is to know whose…

  7. Respondió en I can serve the two little fish orders while the big one waits. How many times?

    Haven't seen her again. Keeping that question before I change the board a second time.

  8. Respondió en I can serve the two little fish orders while the big one waits. How many times?

    We put two chalk marks at most beside a waiting order. Tried it at the stall this morning. Big order through, two people bought something else while waiting. No victory speech: one customer hated it…

  9. Respondió en I can serve the two little fish orders while the big one waits. How many times?

    lol he has just asked to be included in the statistics as a historical monument.

  10. Inició I can serve the two little fish orders while the big one waits. How many times?

    Small stall. One till. The evening queue moves beautifully if I give the little orders their own turn. We tried it with paper orders at the kitchen table. My brother added his big order at the back a…