BarryMcGillin
asked on
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.
...
Anyone can unveil what this '^' operator is and does? It looks like 'NOT' but I cant confirm it anywhere
Thanks
B
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 ) ) ;
...Anyone can unveil what this '^' operator is and does? It looks like 'NOT' but I cant confirm it anywhere
Thanks
B
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
+ Is the results the same if you swap ^ with NOT
+ What do you get with: SELECT 1^1