Re: install pyPgSQL on Windows for python 2.5

2009-03-24 Thread someon
On Mar 24, 4:57 pm, Dietmar Schwertberger 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, > > you need

Re: Escaping optional parameter in WHERE clause

2009-03-23 Thread someon
On Mar 23, 1:48 pm, MRAB 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 pass them to e

Re: Style formating of multiline query, advise

2009-03-23 Thread someon
On Mar 19, 10:26 am, Marco Mariani 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 (with nested s