From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | GPT <gptmailinglists(at)gmail(dot)com> |
Cc: | pgsql-docs(at)postgresql(dot)org |
Subject: | Re: Addition to / Clarification in 9.7.1. LIKE |
Date: | 2018-01-26 13:22:13 |
Message-ID: | 20180126132213.GF20836@momjian.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs |
On Fri, Jan 26, 2018 at 09:52:07AM +0100, GPT wrote:
> Between 1st (The LIKE expression...) and 2nd (If pattern does not...)
> paragraphs, it could be added something like:
>
> <begin>
> Caution
> Contrary to some other databases, in Postgresql only two characters
> are used in LIKE patterns: underscore (_) and percent sign (%).
> The use of any other character will lead to an error.
> <end>
>
> The error message also would be more clarified to inform user about
> the use of not supported characters.
Uh, I still don't understand what error you are talking about. Here are
some examples:
SELECT 'abc' LIKE 'a_c';
?column?
----------
t
SELECT 'abc' LIKE 'a%c';
?column?
----------
t
SELECT 'abc' LIKE 'a%*c';
?column?
----------
f
Can you show me an example?
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ As you are, so once was I. As I am, so you will be. +
+ Ancient Roman grave inscription +
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paquier | 2018-01-26 13:28:07 | Re: Correction of intermediate certificate handling |
Previous Message | Bruce Momjian | 2018-01-26 13:09:30 | Re: Correction of intermediate certificate handling |