I should clarify... != sometimes works on PostgreSQL and sometimes does not. I was seeing some very strange errors when doing certain queries. It looked like != worked fine when I only had one comparison in my SELECT/UPDATE, but as soon as I had multiple comparisons (one of which used !=) I got errors.
Regards, Peter On Fri, 2012-05-04 at 19:22 +0200, Peter Dunkley wrote: > Module: sip-router > Branch: master > Commit: 79e59ec116c14d3416803736a920d9ac478c6055 > URL: > http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=79e59ec116c14d3416803736a920d9ac478c6055 > > Author: Peter Dunkley <[email protected]> > Committer: Peter Dunkley <[email protected]> > Date: Fri May 4 18:14:06 2012 +0100 > > lib/srdb1: Changed OP_NEQ to use ANSI standard <> > > - OP_NEQ was "!=" which works with many, but not all, SQL databases. > - One database this doesn't work with is PostgreSQL. > - <> is the standard and all databases should support it. > > --- > > lib/srdb1/db_op.h | 2 +- > 1 files changed, 1 insertions(+), 1 deletions(-) > > diff --git a/lib/srdb1/db_op.h b/lib/srdb1/db_op.h > index 4b4c3a4..2da6e1f 100644 > --- a/lib/srdb1/db_op.h > +++ b/lib/srdb1/db_op.h > @@ -41,7 +41,7 @@ > /** operator greater than equal */ > #define OP_GEQ ">=" > /** operator negation */ > -#define OP_NEQ "!=" > +#define OP_NEQ "<>" > /** bitwise AND */ > #define OP_BITWISE_AND "&" > > > > _______________________________________________ > sr-dev mailing list > [email protected] > http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev -- Peter Dunkley Technical Director Crocodile RCS Ltd
_______________________________________________ sr-dev mailing list [email protected] http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev
