Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change

Re: left align an unordered list

by Abigail-II (Bishop)
on Jun 24, 2004 at 13:34 UTC ( #369351=note: print w/replies, xml ) Need Help??

in reply to Re^2: left align an unordered list
in thread left align an unordered list

Google, meet Anonymous Monk. Anonymous Monk, meet google.

Replies are listed 'Best First'.

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://369351]
[Corion]: Meh. SQL window functions would even make pagination easy/trivial (but not performant), as rank() over (partition by user order by timestamp) / 10 as page would give me a page number for each item, with 10 items per page.
[Corion]: Of course, the query performance for "all items on page 10" is likely worse than rank() between 100 and 109 , but if that means I can write 15 lines of SQL instead of needing to think about how to partition things and how to encode the page size...
[Corion]: ... that would be nice. But alas, I'm currently tied to SQLite as minimum implementation, and it doesn't implement window functions :-(

How do I use this? | Other CB clients
Other Users?
Others having an uproarious good time at the Monastery: (13)
As of 2018-03-22 12:17 GMT
Find Nodes?
    Voting Booth?
    When I think of a mole I think of:

    Results (274 votes). Check out past polls.