more likely to trip up the novice when working with NOT IN than when working with IN. It’s best to express your condition positively if possible. 9.17.3. ANY/SOME (array) expression operator ANY (array Hash indexes express only bitwise equality, and so they use only one strategy, shown in Table 32-3. Table 32-3. Hash Strategies Operation Strategy Number equal 1 R-tree indexes express relationships is provided by ALTER TABLE, not by ALTER TRIGGER, because ALTER TRIGGER has no convenient way to express the option of enabling or disabling all of a table’s triggers at once. Examples To rename an existing

more likely to trip up the novice when working with NOT IN than when working with IN. It’s best to express your condition positively if possible. 9.17.3. ANY/SOME (array) expression operator ANY (array Hash indexes express only bitwise equality, and so they use only one strategy, shown in Table 32-3. Table 32-3. Hash Strategies Operation Strategy Number equal 1 R-tree indexes express relationships is provided by ALTER TABLE, not by ALTER TRIGGER, because ALTER TRIGGER has no convenient way to express the option of enabling or disabling all of a table’s triggers at once. Examples To rename an existing

more likely to trip up the novice when working with NOT IN than when working with IN. It’s best to express your condition positively if possible. 9.17.3. ANY/SOME (array) expression operator ANY (array PostgreSQL. Currently, only the DTrace utility is supported, which is only available on Solaris Express and Solaris 10+. It is expected that DTrace will be available in the future on FreeBSD and Mac OS less than 1 less than or equal 2 equal 3 greater than or equal 4 greater than 5 Hash indexes express only bitwise equality, and so they use only one strategy, shown in Table 33-3. Table 33-3. Hash

more likely to trip up the novice when working with NOT IN than when working with IN. It’s best to express your condition positively if possible. 9.17.3. ANY/SOME (array) expression operator ANY (array PostgreSQL. Currently, only the DTrace utility is supported, which is only available on Solaris Express and Solaris 10+. It is expected that DTrace will be available in the future on FreeBSD and Mac OS less than 1 less than or equal 2 equal 3 greater than or equal 4 greater than 5 Hash indexes express only bitwise equality, and so they use only one strategy, shown in Table 33-3. Table 33-3. Hash

more likely to trip up the novice when working with NOT IN than when working with IN. It’s best to express your condition positively if possible. 9.17.3. ANY/SOME (array) expression operator ANY (array less than 1 less than or equal 2 equal 3 greater than or equal 4 greater than 5 Hash indexes express only bitwise equality, and so they use only one strategy, shown in Table 31-3. 519 Chapter 31. Extending SQL Table 31-3. Hash Strategies Operation Strategy Number equal 1 R-tree indexes express rectangle-containment relationships. They use eight strategies, shown in Table 31-4. Table 31-4

more likely to trip up the novice when working with NOT IN than when working with IN. It’s best to express your condition positively if possible. 9.17.3. ANY/SOME (array) expression operator ANY (array Hash indexes express only bitwise equality, and so they use only one strategy, shown in Table 31-3. Table 31-3. Hash Strategies Operation Strategy Number equal 1 R-tree indexes express rectangle-containment

more likely to trip up the novice when working with NOT IN than when working with IN. It is best to express your condition positively if possible. 9.23.3. ANY/SOME (array) expression operator ANY (array PostgreSQL on Windows. The simplest way to build with Microsoft tools is to install Visual Studio Express 2012 for Windows Desktop and use the included compiler. It is also possible to build with the full C++ compiler suite from Microsoft. These compilers can be either from Visual Studio, Visual Studio Express or some versions of the Microsoft Windows SDK. If you do not already have a Visual Studio environment

more likely to trip up the novice when working with NOT IN than when working with IN. It is best to express your condition positively if possible. 9.23.3. ANY/SOME (array) expression operator ANY (array PostgreSQL on Windows. The simplest way to build with Microsoft tools is to install Visual Studio Express 2012 for Windows Desktop and use the included com- piler. It is also possible to build with the full C++ compiler suite from Microsoft. These compilers can be either from Visual Studio, Visual Studio Express or some versions of the Microsoft Windows SDK. If you do not already have a Visual Studio environment

more likely to trip up the novice when working with NOT IN than when working with IN. It is best to express your condition positively if possible. 9.23.3. ANY/SOME (array) expression operator ANY (array PostgreSQL on Windows. The simplest way to build with Microsoft tools is to install Visual Studio Express 2017 for Windows Desktop and use the included compiler. It is also possible to build with the full Studio Express or some versions of the Microsoft Windows SDK. If you do not already have a Visual Studio environment set up, the easiest ways are to use the compilers from Visual Studio Express 2017 for

more likely to trip up the novice when working with NOT IN than when working with IN. It is best to express your condition positively if possible. 9.23.3. ANY/SOME (array) expression operator ANY (array PostgreSQL on Windows. The simplest way to build with Mi- crosoft tools is to install Visual Studio Express 2017 for Windows Desktop and use the included compiler. It is also possible to build with the full Studio Express or some versions of the Microsoft Windows SDK. If you do not already have a Visual Studio environment set up, the easiest ways are to use the compilers from Visual Studio Express 2017 for