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

  • Testing functions in Perl

    (Nothing particularly profound or my-idea-centric here, and I was tempted to post it to my personal blog instead, but it's worth trying to learn…

  • Abstract strategies for abstraction

    There are a few purposes of abstraction in programming; one of them is to construct a uniform API that is independent of the backend that can work…

  • Statistical Software Components

    A few months ago I mentioned my big library of useful generic C/Perl functions (libpgunn). There are plenty of other general-purpose libraries out…

  • 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