On Apr 25, 2011, at 1:08 AM, Marco wrote: > > I would create a min and max columns in that same table or in a > separate "index" table, and parse the value in advance so that the min > column has the 1 and the max column the 3, then you can issue a normal > query against the two columns. For single values max=min. > I am sure that there are ways to write stored procedures for doing > this inline within a query, but each query would trigger a table scan > and perform poorly. I would love to know if I am wrong, as this is an > issue that I will also need to resolve. > Marco
you're correct on all points. > > On Apr 24, 5:15 am, Andrew Volozhanin <linuxhead...@gmail.com> wrote: >> Hello everyone. >> >> I'm having a problem with filtering SELECT results. >> I've got a table with a column "capacity" which contains values like "1-3 >> kW", "5 kW"..etc >> And i've got some filter search with user text input which submit the needed >> capacity. (let's say '2') >> So, i need to be able to obtain first entry (with '1-3 kW') as a result of >> user's submission '2'. >> In other words, how can i explain to the filter function that user's number >> '2' contains in '1-3' range from the table. >> >> PS I hope you'll understand what i'm trying to say.) > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To post to this group, send email to sqlalchemy@googlegroups.com. > To unsubscribe from this group, send email to > sqlalchemy+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/sqlalchemy?hl=en. > -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
