Обсуждение: What is the regex for apostraphe in postgres?

Поиск
Список
Период
Сортировка

What is the regex for apostraphe in postgres?

От
Shaozhong SHI
Дата:
Can we check whether a text string contains apostraphe ' of not?

Regards,

David

Re: What is the regex for apostraphe in postgres?

От
"Torsten Grust"
Дата:
Hi David,

in a SQL string literal (or regular expression), an apostrophe is represented by '' (double apostrophe):

  SELECT 'foo''bar' SIMILAR TO '_+''_+';
  -> #t

Cheers,
  —T

On Thu, Oct 14, 2021, at 12:31, Shaozhong SHI wrote:
Can we check whether a text string contains apostraphe ' of not?

Regards,

David

--
| Torsten Grust
| teggy@fastmail.com


Re: What is the regex for apostraphe in postgres?

От
Steve Midgley
Дата:


On Thu, Oct 14, 2021 at 5:35 AM Torsten Grust <teggy@fastmail.com> wrote:
Hi David,

in a SQL string literal (or regular expression), an apostrophe is represented by '' (double apostrophe):

  SELECT 'foo''bar' SIMILAR TO '_+''_+';
  -> #t

Cheers,
  —T

On Thu, Oct 14, 2021, at 12:31, Shaozhong SHI wrote:
Can we check whether a text string contains apostraphe ' of not?

Regards,

David

 
I think it's helpful to clarify that "double apostrophe" means in this context a single apostrophe twice (ie '  ' ), not the single character "double apostrophe" (ie ")