<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/4.2.3">
</HEAD>
<BODY>
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.<BR>
<BR>
Regards,<BR>
<BR>
Peter<BR>
<BR>
On Fri, 2012-05-04 at 19:22 +0200, Peter Dunkley wrote:
<BLOCKQUOTE TYPE=CITE>
<PRE>
Module: sip-router
Branch: master
Commit: 79e59ec116c14d3416803736a920d9ac478c6055
URL: <A HREF="http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=79e59ec116c14d3416803736a920d9ac478c6055">http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=79e59ec116c14d3416803736a920d9ac478c6055</A>
Author: Peter Dunkley <<A HREF="mailto:peter.dunkley@crocodile-rcs.com">peter.dunkley@crocodile-rcs.com</A>>
Committer: Peter Dunkley <<A HREF="mailto:peter.dunkley@crocodile-rcs.com">peter.dunkley@crocodile-rcs.com</A>>
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
<A HREF="mailto:sr-dev@lists.sip-router.org">sr-dev@lists.sip-router.org</A>
<A HREF="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev</A>
</PRE>
</BLOCKQUOTE>
<BR>
<TABLE CELLSPACING="0" CELLPADDING="0" WIDTH="100%">
<TR>
<TD>
<PRE>
--
Peter Dunkley
Technical Director
Crocodile RCS Ltd
</PRE>
</TD>
</TR>
</TABLE>
</BODY>
</HTML>