Matches in SemOpenAlex for { <https://semopenalex.org/work/W1182925837> ?p ?o ?g. }
Showing items 1 to 82 of
82
with 100 items per page.
- W1182925837 abstract "This chapter focuses on the comparison and theta operators in SQL. The large number of data types in SQL makes doing comparisons a little harder than in other programming languages. Values of one data type have to be promoted to values of the other data type before the comparison can be done. The comparison operators are overloaded and work for , , and data types. They return a logical value of TRUE, FALSE, or UNKNOWN where the values TRUE and FALSE follow the usual rules, and UNKNOWN is always returned when one or both of the operands is a NULL. Numeric data types are mutually comparable and mutually assignable. Floating-point hardware often affects comparisons for REAL, FLOAT, and DOUBLEPRECISION numbers, and there is no way to avoid this, since it is not always reasonable to use DECIMAL or NUMERIC in their place. CHARACTER and CHARACTER VARYING data types are comparable if they are taken from the same character repertoire. The comparison takes the shorter of the two strings and pads it with spaces. The strings are compared position by position from left to right, using the collating sequence for the repertoire. Standard SQL generalized the theta operators so that they would work on row expressions and not just on scalars, which makes SQL more orthogonal and gives an intuitive feel to it." @default.
- W1182925837 created "2016-06-24" @default.
- W1182925837 creator A5066287408 @default.
- W1182925837 date "2011-01-01" @default.
- W1182925837 modified "2023-09-25" @default.
- W1182925837 title "Comparison or Theta Operators" @default.
- W1182925837 doi "https://doi.org/10.1016/b978-0-12-382022-8.00016-8" @default.
- W1182925837 hasPublicationYear "2011" @default.
- W1182925837 type Work @default.
- W1182925837 sameAs 1182925837 @default.
- W1182925837 citedByCount "0" @default.
- W1182925837 crossrefType "book-chapter" @default.
- W1182925837 hasAuthorship W1182925837A5066287408 @default.
- W1182925837 hasConcept C11413529 @default.
- W1182925837 hasConcept C119857082 @default.
- W1182925837 hasConcept C138958017 @default.
- W1182925837 hasConcept C18903297 @default.
- W1182925837 hasConcept C199360897 @default.
- W1182925837 hasConcept C203763787 @default.
- W1182925837 hasConcept C2524010 @default.
- W1182925837 hasConcept C2776291640 @default.
- W1182925837 hasConcept C2777299769 @default.
- W1182925837 hasConcept C2778112365 @default.
- W1182925837 hasConcept C2780861071 @default.
- W1182925837 hasConcept C28719098 @default.
- W1182925837 hasConcept C33923547 @default.
- W1182925837 hasConcept C41008148 @default.
- W1182925837 hasConcept C510870499 @default.
- W1182925837 hasConcept C54355233 @default.
- W1182925837 hasConcept C55526617 @default.
- W1182925837 hasConcept C65045869 @default.
- W1182925837 hasConcept C77088390 @default.
- W1182925837 hasConcept C86803240 @default.
- W1182925837 hasConcept C94375191 @default.
- W1182925837 hasConceptScore W1182925837C11413529 @default.
- W1182925837 hasConceptScore W1182925837C119857082 @default.
- W1182925837 hasConceptScore W1182925837C138958017 @default.
- W1182925837 hasConceptScore W1182925837C18903297 @default.
- W1182925837 hasConceptScore W1182925837C199360897 @default.
- W1182925837 hasConceptScore W1182925837C203763787 @default.
- W1182925837 hasConceptScore W1182925837C2524010 @default.
- W1182925837 hasConceptScore W1182925837C2776291640 @default.
- W1182925837 hasConceptScore W1182925837C2777299769 @default.
- W1182925837 hasConceptScore W1182925837C2778112365 @default.
- W1182925837 hasConceptScore W1182925837C2780861071 @default.
- W1182925837 hasConceptScore W1182925837C28719098 @default.
- W1182925837 hasConceptScore W1182925837C33923547 @default.
- W1182925837 hasConceptScore W1182925837C41008148 @default.
- W1182925837 hasConceptScore W1182925837C510870499 @default.
- W1182925837 hasConceptScore W1182925837C54355233 @default.
- W1182925837 hasConceptScore W1182925837C55526617 @default.
- W1182925837 hasConceptScore W1182925837C65045869 @default.
- W1182925837 hasConceptScore W1182925837C77088390 @default.
- W1182925837 hasConceptScore W1182925837C86803240 @default.
- W1182925837 hasConceptScore W1182925837C94375191 @default.
- W1182925837 hasLocation W11829258371 @default.
- W1182925837 hasOpenAccess W1182925837 @default.
- W1182925837 hasPrimaryLocation W11829258371 @default.
- W1182925837 hasRelatedWork W1034459751 @default.
- W1182925837 hasRelatedWork W161227145 @default.
- W1182925837 hasRelatedWork W1881756298 @default.
- W1182925837 hasRelatedWork W1971133057 @default.
- W1182925837 hasRelatedWork W2049847852 @default.
- W1182925837 hasRelatedWork W2096212834 @default.
- W1182925837 hasRelatedWork W2319231980 @default.
- W1182925837 hasRelatedWork W2481073037 @default.
- W1182925837 hasRelatedWork W2485138076 @default.
- W1182925837 hasRelatedWork W2496079821 @default.
- W1182925837 hasRelatedWork W2498679499 @default.
- W1182925837 hasRelatedWork W2506922720 @default.
- W1182925837 hasRelatedWork W2585276060 @default.
- W1182925837 hasRelatedWork W2592401541 @default.
- W1182925837 hasRelatedWork W3020860597 @default.
- W1182925837 hasRelatedWork W3021754695 @default.
- W1182925837 hasRelatedWork W3022329652 @default.
- W1182925837 hasRelatedWork W3023370424 @default.
- W1182925837 hasRelatedWork W32207062 @default.
- W1182925837 hasRelatedWork W953130165 @default.
- W1182925837 isParatext "false" @default.
- W1182925837 isRetracted "false" @default.
- W1182925837 magId "1182925837" @default.
- W1182925837 workType "book-chapter" @default.