Re: [PyWrapper-devel] SQL syntax

[<wi...@go...>]

Milko,
for programming it would be easier to have isNotNull. But we dont wanna
change TAPIR and its really more consistent to NOT have it.

So we gotta solve that. its a dbmod problem.
ive just tried with mysql5.0 and something like this works fine:

SELECT * FROM taxon WHERE NOT synonyms IS NULL

what version are you using?
can you try to do a simple statement like the above?
if it doesnt work, how about enclosing is null in brackets like this:

SELECT * FROM taxon WHERE NOT (synonyms IS NULL)

please let me know!
markus

On 11/14/06, Skofic A. Milko (IPGRI) <m.s...@cg...> wrote:
>
> I was looking at how TAPIR resolves the SQL syntax for selecting not nullelements it does:WHERE(
> *NOT* table.field IS NULL )
> the problem is that it is not the correct syntax, the correct one is:
> WHERE( table.field IS *NOT* NULL )
>
> Wouldn't it be easier to add "isNotNull" to the unary operators?
>