Teradata ^ operator

Hi Guys,
I've inherited a program which has some teradata access in it and one part of the query has me stumped as I dont know what it does or how its meant to operate.  

This particular example is on a group by clause  like this with the '^' operator.

...
GROUP BY 1 , 2 , 3 , 4 , 5 ) chk 
WHERE ( ^ ( CAST( one_id AS INT ) = 9772 
 AND two_id = 12192 ) ) ;

Open in new window

...

Anyone can unveil what this '^' operator is and does?  It looks like 'NOT'  but I cant confirm it anywhere
Thanks
B
LVL 2
BarryMcGillinAsked:
Who is Participating?
 
ispalenyConnect With a Mentor Commented:
The following comparison operators are Teradata extensions to the ANSI SQL:2008 standard.
Their use is deprecated.

EQ
^=
NE
NOT=
LT
LE
GT
GE

You should use <> instead of ^=.

It looks like ^ is a deprecated Teradata version of NOT operator.

But it is not documented at least since V2R6.0.0(oldest docs available online).
0
 
Kevin CrossChief Technology OfficerCommented:
My understanding was that is a bitwise operator.  Additionally, every reference I have seen for the Teradata logical operators has the keyword NOT; therefore, 2 sanity checks:

+ Is the results the same if you swap ^ with NOT
+ What do you get with: SELECT 1^1
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.