On Mon, Apr 23, 2007 at 07:11:04PM -0300, Jorge Godoy wrote:
> So you have a "go" from me. It worked flawless.
Thank you!
Oleg.
--
Oleg Broytmannhttp://phd.pp.ru/[EMAIL PROTECTED]
Programmers don't die, they just GOSUB without RETURN.
---
Oleg Broytmann <[EMAIL PROTECTED]> writes:
> On Mon, Apr 23, 2007 at 04:13:57PM -0300, Jorge Godoy wrote:
>> >Jorge, can you replace sqlbuilder._LikeQuoted.__sqlrepr__() with the
>> > following and test if works for you?
>>
>> I'll do that tonight. I'm working at my client's office now and a
On Mon, Apr 23, 2007 at 04:13:57PM -0300, Jorge Godoy wrote:
> >Jorge, can you replace sqlbuilder._LikeQuoted.__sqlrepr__() with the
> > following and test if works for you?
>
> I'll do that tonight. I'm working at my client's office now and as soon
> as I get to my office I'll test it for yo
Oleg Broytmann <[EMAIL PROTECTED]> writes:
> On Sun, Apr 22, 2007 at 09:27:02PM +0400, Oleg Broytmann wrote:
>> On Sun, Apr 22, 2007 at 02:05:36PM -0300, Jorge Godoy wrote:
>> >
>> > model.VResultadoResumo.q.nomePacienteNormalizado.startswith(
>> > func.f_v_tex
On Sun, Apr 22, 2007 at 09:27:02PM +0400, Oleg Broytmann wrote:
> On Sun, Apr 22, 2007 at 02:05:36PM -0300, Jorge Godoy wrote:
> > model.VResultadoResumo.q.nomePacienteNormalizado.startswith(
> > func.f_v_texto(nome_paciente)))
> [skip]
> > ((neolab.v_resultados_
Oleg Broytmann <[EMAIL PROTECTED]> writes:
> On Sun, Apr 22, 2007 at 03:12:05PM -0300, Jorge Godoy wrote:
>> I prefer writing Python inside the database as
>> well. :-)
>
>Postgres allows it, with some limitations as far as I heard...
I haven't noticed the limitations :-) And it works very
On Sun, Apr 22, 2007 at 03:12:05PM -0300, Jorge Godoy wrote:
> I prefer writing Python inside the database as
> well. :-)
Postgres allows it, with some limitations as far as I heard...
Oleg.
--
Oleg Broytmannhttp://phd.pp.ru/[EMAIL PROTECTED]
Programm
Oleg Broytmann <[EMAIL PROTECTED]> writes:
>I will think on how to fix _LikeQuoted...
Thanks! As a temporary fix I've appended the percent sign myself.
>Probably. I didn't write SQL for quite a lot of time. :)
It is fun ;-) But I prefer writing Python inside the database as
well. :-
On Sun, Apr 22, 2007 at 02:54:02PM -0300, Jorge Godoy wrote:
> > ((neolab.v_resultados_resumo.nome_paciente_normalizado) LIKE
> > (f_v_texto('jo'))) + '%')
>
> That's OK.
I will think on how to fix _LikeQuoted...
> I believe that you meant:
>
> ((neolab.v_resultados_resumo.nome_paciente_nor
Oleg Broytmann <[EMAIL PROTECTED]> writes:
> In any case, even when I fix sqlbuilder, this
>
>> model.VResultadoResumo.q.nomePacienteNormalizado.startswith(
>> func.f_v_texto(nome_paciente)))
>
>doesn't mean
>
>> ((neolab.v_resultados_resumo.nome_paciente_no
In any case, even when I fix sqlbuilder, this
> model.VResultadoResumo.q.nomePacienteNormalizado.startswith(
> func.f_v_texto(nome_paciente)))
doesn't mean
> ((neolab.v_resultados_resumo.nome_paciente_normalizado) LIKE
> (f_v_texto('jo%'
It means
(
On Sun, Apr 22, 2007 at 02:05:36PM -0300, Jorge Godoy wrote:
> model.VResultadoResumo.q.nomePacienteNormalizado.startswith(
> func.f_v_texto(nome_paciente)))
[skip]
> ((neolab.v_resultados_resumo.nome_paciente_normalizado) LIKE
> ('_v_texto('jo'%'))) ORDER BY id
Jorge Godoy <[EMAIL PROTECTED]> writes:
If I change:
>
> if nome_paciente:
> amostras = amostras.filter(
> model.VResultadoResumo.q.nomePacienteNormalizado.startswith(
>
13 matches
Mail list logo
