Re: install pyPgSQL on Windows for python 2.5

2009-03-24 Thread someon
On Mar 24, 4:57 pm, Dietmar Schwertberger n...@schwertberger.de wrote: someone wrote: Hi, does anyone know how to install pyPgSQL on Windows? There is no package for Python 2.5 on Homepage: I've installed newest Visual C++ Studio 2008 from Microsoft, but still no luck Hello Pet,

Re: Style formating of multiline query, advise

2009-03-23 Thread someon
On Mar 19, 10:26 am, Marco Mariani ma...@sferacarta.com wrote: someone wrote: Also, for SQL, (A) why are you using nested joins?, and inner select produce smaller set which is then joined with other table, kind a optimization Did you time it? I've did explain on both kinds of query

Re: Escaping optional parameter in WHERE clause

2009-03-23 Thread someon
On Mar 23, 1:48 pm, MRAB goo...@mrabarnett.plus.com wrote: someone wrote: Hi, as you can see below I have some optional parameter for my query (mf, age). They are in WHERE clause only if not empty. In this function they are not escaped as, for example, 'search' parameter, cause I can't