Search Postgresql Archives

Re: Receiving many more rows than expected

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 05/09/2014 08:14 AM, Vincent de Phily wrote:
On Friday 09 May 2014 08:01:47 Adrian Klaver wrote:
On 05/09/2014 01:45 AM, Vincent de Phily wrote:
Before you grow suspicious of that conf_getint, the config is loaded once
at program startup, and the overlarge results hapen together with normal
results without having left the loop. Just in case I'm now logging the
query string anyway; who knows...

As proof of concept that the value can change in the loop:


In [17]: l = [1, 2, 3, 4, 5]

In [18]: def getNumber():
      return random.choice(l)
     ....:

In [19]: ct = 0

In [20]: while ct < 5:
      s = 'Lucky number is %d' % (getNumber(),)
      ct += 1
      print s
     ....:
Lucky number is 5
Lucky number is 5
Lucky number is 4
Lucky number is 3
Lucky number is 2

Sure, but that's not what I'm doing at all. My "str" % (somefunc(),) is
executed outside the loop, not inside it. This is python, not lisp. The
variable "query" is a plain string, not a reference to how that string was
created.

My mistake, what I get for trying to throw something together while heading out the door :(





--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux