Home > mailing lists

Re: What is the regex for apostraphe in postgres? - Mailing list pgsql-sql

From	Torsten Grust
Subject	Re: What is the regex for apostraphe in postgres?
Date	October 14, 2021 15:35:02
Msg-id	e0d3c0e0-2735-49ea-88e3-176f11324303@www.fastmail.com Whole thread Raw
In response to	What is the regex for apostraphe in postgres? (Shaozhong SHI <shishaozhong@gmail.com>)
Responses	Re: What is the regex for apostraphe in postgres?
List	pgsql-sql

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

From: "David G. Johnston"
Date: 14 October 2021, 15:31:04
Subject: Re: What is the regex for apostraphe in postgres

From: Metin Ulusinan
Date: 14 October 2021, 16:42:23
Subject: Re: Fault with initcap