Numeric Operators in SQL Where clauses
I’ve worked on a number of large Omnis projects where the initial intent was to have the code be SQL-agnostic. The belief was that it would be a great sales advantage to say to your customer, “you can use Oracle or Postgres or MySQL or SQLServer…”
In each of the cases, the company eventually picked one and went with it. In their learned experience, the extra sales brought in by being able to choose their flavour of DB was not worth the extra labour, code branching, and maintenance to support multiple backends. I just didn’t pay off.
To quote a a saying I quite like, “Is the view worth the climb?” In this case, we found it wasn’t.
If folks want your product, it’s for what it can do for them. They are less concerned about how you go about it.
Postgres is a great choice if you were to pick just one.
“Straight ahead and strive for tone.” — Frank Marocco
> On 20180202, at 16:48, Das Goravani <email@example.com> wrote:
> My business reason is to have less work in case of a client wanting to use something OTHER THAN Postgres.