sqlite - Comparisons And Types

Not logged in

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

• Contents
• Diff
• Text

I could not find any info on converting and comparing to avoid type confusion. Is there a way to guarentee that comparisons are of a given type?

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)

---

Please use the mailing list to ask questions like this. See http://www.sqlite.org/support.html for instructions on how to access the mailing list.

Reply: Pardon my question, but doesn't a maillist defeat the purpose of a wiki? The wiki avoids reinventing the wheel when another person has the same issue or question.