Re: What is the regex for apostraphe in postgres?
От
Torsten Grust
Тема
Re: What is the regex for apostraphe in postgres?
Дата
Msg-id
e0d3c0e0-2735-49ea-88e3-176f11324303@www.fastmail.com
Ответ на
What is the regex for apostraphe in postgres? (Shaozhong SHI)
Список
Дерево обсуждения
What is the regex for apostraphe in postgres? Shaozhong SHI <shishaozhong@gmail.com>
Re: What is the regex for apostraphe in postgres? "Torsten Grust" <teggy@fastmail.com>
Re: What is the regex for apostraphe in postgres? Steve Midgley <science@misuse.org>
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
В списке pgsql-sql по дате отправления
