Go Premium for a chance to win a PS4. Enter to Win


Teradata ^ operator

Posted on 2011-02-11
Medium Priority
Last Modified: 2013-11-11
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
Question by:BarryMcGillin
LVL 60

Expert Comment

by:Kevin Cross
ID: 34873666
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
LVL 13

Accepted Solution

ispaleny earned 2000 total points
ID: 34989553
The following comparison operators are Teradata extensions to the ANSI SQL:2008 standard.
Their use is deprecated.


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).

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …

971 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question