Re: What is the regex for apostraphe in postgres

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Shaozhong SHI <shishaozhong(at)gmail(dot)com>
Cc: pgsql-sql <pgsql-sql(at)lists(dot)postgresql(dot)org>
Subject: Re: What is the regex for apostraphe in postgres
Date: 2021-10-14 12:31:04
Message-ID: CAKFQuwZOUibf_X0xxruXz_PMBhBGCSemRcGNkP3FF8d=9Q6ZAA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Thursday, October 14, 2021, Shaozhong SHI <shishaozhong(at)gmail(dot)com> wrote:

> Can we check whether a text string contains apostraphe ' of not?
>
>
Yes. But if you write the regex using single quotes to denote the literal
you need to follow sql literal writing conventions for escaping the single
quote inside the literal. This is documented.

David J.

Browse pgsql-sql by date

  From Date Subject
Next Message Torsten Grust 2021-10-14 12:35:02 Re: What is the regex for apostraphe in postgres?
Previous Message Shaozhong SHI 2021-10-14 10:31:18 What is the regex for apostraphe in postgres?