1

As you might imagine, I'm having a hard time Googlin' for this, does anyone know why <> and != both exist, especially if they're identical?

My best guess is one is SQL standard or it's historical, but I was hoping someone knew the actual reason. This might apply to more than postgres also...

munchybunch
  • 6,033
  • 11
  • 48
  • 62

1 Answers1

5

The official SQL standard operator for inequality is <>, but due to the popularity of C and C-like languages (eg java), practically all databases support != as an alternative for <>.

There is no effective difference between them.

Bohemian
  • 412,405
  • 93
  • 575
  • 722