Re: Receiving many more rows than expected

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: Receiving many more rows than expected
Дата
Msg-id 536D4531.30807@aklaver.com
обсуждение исходный текст
Ответ на Re: Receiving many more rows than expected  (Vincent de Phily <vincent.dephily@mobile-devices.fr>)
Список pgsql-general
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@aklaver.com


В списке pgsql-general по дате отправления:

Предыдущее
От: Randy Westlund
Дата:
Сообщение: Re: Enforce Symmetric Matrix
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Receiving many more rows than expected