Numeric Operators in SQL Where clauses
Please define “generic sql.” 😉
There are multiple SQL specifications with different levels of conformance and every backend implements these specifications quite differently. Are you trying to build your app to support multiple SQL engines? If so, I hope it’s for a very good business reason because doing so is a pain.
www.postgresql.org/docs/10/static/features.html <www.postgresql.org/docs/10/static/features.html> outlines these different specifications and then goes into how PostgreSQL adheres to them. The casting feature I referenced is listed on the supported features page with identifier F201.
> On Feb 2, 2018, at 16:22, Das Goravani <firstname.lastname@example.org> wrote:
> Do you know the way to do it which is GENERIC SQL
>> On Feb 2, 2018, at 1:10 PM, Alex Clay <email@example.com> wrote:
>> You need to cast the numeric field to a character type. For PostgreSQL:
>>> WHERE prod_id::text LIKE ‘[isearchtext]%’
> Manage your list subscriptions at lists.omnis-dev.com
> Start a new message -> mailto:firstname.lastname@example.org