Radicore Forum: Bug Reports » postgresql error using lower/upper/ilike functions

Home » RADICORE development » Bug Reports » postgresql error using lower/upper/ilike functions (Case insensitive searching postgresql)

Sun, 05 March 2017 05:43

AJM
Messages: 2367
Registered: April 2006
Location: Surrey, UK

Senior Member

I have amended include.library.inc so that it will allow both of the following in the WHERE string:

lower(product_name) LIKE '%hello%'"
product_name ILIKE '%hello%'

[Updated on: Mon, 06 March 2017 03:40]

		postgresql error using lower/upper/ilike functions By: renato on Sat, 04 March 2017 22:43
		Re: postgresql error using lower/upper/ilike functions By: AJM on Sun, 05 March 2017 05:43
		Re: postgresql error using lower/upper/ilike functions By: renato on Mon, 06 March 2017 12:39
		Re: postgresql error using lower/upper/ilike functions By: apmuthu on Wed, 12 April 2017 16:12
		Re: postgresql error using lower/upper/ilike functions By: AJM on Wed, 12 April 2017 18:10
		Re: postgresql error using lower/upper/ilike functions By: apmuthu on Sun, 16 April 2017 06:47
		Re: postgresql error using lower/upper/ilike functions By: AJM on Sun, 16 April 2017 08:24
		Re: postgresql error using lower/upper/ilike functions By: apmuthu on Sun, 16 April 2017 11:21
		Re: postgresql error using lower/upper/ilike functions By: AJM on Mon, 17 April 2017 04:49
		Re: postgresql error using lower/upper/ilike functions By: Triolo on Fri, 28 April 2017 00:58
		Re: postgresql error using lower/upper/ilike functions By: AJM on Fri, 28 April 2017 04:38

Previous Topic:	Legacy file carryover
Next Topic:	Regex and Sql Queries containing +

Goto Forum:

] [

]

Current Time: Fri Nov 22 02:57:45 EST 2024

Total time taken to generate the page: 0.01027 seconds