sqlite - Comparisons And Types

Not logged in

• Honeypot
• Browse
• Home
• Login
• Reports
• Search
• Ticket
• Timeline
• Wiki

• Contents
• No-Diff
• Text

*** 2,9 ****
  
  For example, I am looking for something like:
  
!   ...WHERE NUMBER(A) > NUMBER(B)
  
!   ...ORDER BY NUMBER(X), STRING(Y)
  
  In other words, how does one guarentee that comparisons are being interpreted as the needed or expected type? (This is assuming I don't want to pre-declare column types)
--- 2,9 ----
  
  For example, I am looking for something like:
  
!   ...WHERE NUMBER(A) > NUMBER(B)  // dummy sql
  
!   ...ORDER BY NUMBER(X), STRING(Y)  // dummy sql
  
  In other words, how does one guarentee that comparisons are being interpreted as the needed or expected type? (This is assuming I don't want to pre-declare column types)