midB2
Joined 11 June 2024
Posts in the forum
-
Replied in 同一张桌子,为什么来了三个房间?
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.
-
Replied in 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.
-
Replied in 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…
-
Replied in 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.
-
Replied in 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…
-
Started 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…
-
Replied in 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.
-
Replied in 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…
-
Replied in 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.
-
Started 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…