Pat Gunn (dachte) wrote,
Pat Gunn
dachte

Struts under the dock

I've been tweaking the topic code again, and working on thedescriptions for some of the topics. A few are posted, more arenot ready for prime time. One thing I'm surprised about is thatthe postgres query engine can do queries on the results of functionsover selects.. hmm.. that's such a horrible way to word it. Here'swhat I'm surprised works: select * from foo where lower(name)='bill';I wonder if it's mandated by the standard, or if it's an extention..I know it, at least in theory, should be slower than the most efficientway to do equivilence queries could be -- instead of doing clever hashingon the values, it needs to actually iterate over the entire table toconstruct the lowercase version of each foo.name. I wonder if it does"The Right Thing" with queries not using equivilence, instead usingsomething like IN. Anyhow, scoot yourself back to the main page, andcheck out my topics and their descriptions. I also fixed a bug relatingto casing, so the BLOG topic works correctly.

Tonight's another PUSH meeting.. 9pm, Posvar Hall on Pitt campus.. so,R2 or anyone else I know who's expressed interest but hasn't shown up,you're welcome to join us :)

Not quite done with my take-home exam for psych yet. It's due tomorrowmorning. Ugh.

Tags: blog
Subscribe

  • Still alive

    Been feeling a bit nostalgic. Not about to return to LiveJournal - their new ownership is unfortunate, but I wanted to briefly note what's been up…

  • Unplugging LJ

    It's about time I pulled the plug on the LJ version of my blog: 1) I'm much more active on G+ than I am with general blogging. I post many times a…

  • Mutual Trust

    I don't know which should be considered more remarkable: That a cat should trust a member of a far larger and stronger species that it can't…

  • Post a new comment

    Error

    Anonymous comments are disabled in this journal

    default userpic

    Your reply will be screened

    Your IP address will be recorded 

  • 0 comments