Postgres Pro
Downloads
Home   >   mailing lists

Thread: What is the regex for apostraphe in postgres?

What is the regex for apostraphe in postgres?

From
Shaozhong SHI
Date:
Can we check whether a text string contains apostraphe ' of not?

Regards,

David

Re: What is the regex for apostraphe in postgres?

From
"Torsten Grust"
Date:
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?

From
Steve Midgley
Date:


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 ")