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
  • 5,863
  • 10
  • 46
  • 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
  • 389,931
  • 88
  • 552
  • 692