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