Re: [GENERAL] can't figure string compare result (using also custom C function)

2009-02-14 Thread Edoardo Panfili
Sam Mason ha scritto: On Fri, Feb 13, 2009 at 10:31:49PM +0100, Edoardo Panfili wrote: SELECT idSpecie,nome FROM specienomi WHERE idspecie=37026 and nome='X Agropogon littoralis (Sm.) C.E. Hubb.'; idspecie | nome --+- 37026 |

Re: [GENERAL] can't figure string compare result (using also custom C function)

2009-02-13 Thread Sam Mason
On Fri, Feb 13, 2009 at 10:31:49PM +0100, Edoardo Panfili wrote: > SELECT idSpecie,nome FROM specienomi > WHERE idspecie=37026 and nome='X Agropogon littoralis (Sm.) C.E. Hubb.'; > idspecie | nome > --+- > 37026 | X Agropogon li

Re: [GENERAL] can't figure string compare result (using also custom C function)

2009-02-13 Thread Edoardo Panfili
Sam Mason ha scritto: On Fri, Feb 13, 2009 at 10:31:49PM +0100, Edoardo Panfili wrote: The problem arises only with particular records, when the first character of the string is generated by my function [1]. When the first character is copied from postgres parameter [2] all works fine. [1] bu

Re: [GENERAL] can't figure string compare result (using also custom C function)

2009-02-13 Thread Sam Mason
On Fri, Feb 13, 2009 at 10:31:49PM +0100, Edoardo Panfili wrote: > The problem arises only with particular records, when the first > character of the string is generated by my function [1]. > When the first character is copied from postgres parameter [2] all works > fine. > > [1] buffer[0]='X';