首页 \ 问答 \ 使用未知字符串的String.matches使用“Unclosed count closure”(“Unclosed counted closure” with String.matches using unknown strings)

使用未知字符串的String.matches使用“Unclosed count closure”(“Unclosed counted closure” with String.matches using unknown strings)

 下面的代码  
String str1, str2;

// code that assigns contents to str1 and str2

if (!str1.matches(str2)) something=false;
 
 如果str2包含一个特殊字符，例如{，则产生一个“Unclosed count closure”异常。 如果我不知道str2或str1的内容是什么，我怎么能避免这种情况发生？ 是否可以转义未知字符串中的字符？ 

The following code 
String str1, str2;

// code that assigns contents to str1 and str2

if (!str1.matches(str2)) something=false;
 
produces an "Unclosed counted closure" exception if str2 contains a special character such as {. How can I avoid this happening if I do not know what will be the contents of str2 or str1? Is it possible to escape characters in an unknown string?

原文：https://stackoverflow.com/questions/20752647

更新时间：2022-08-28 09:08

最满意答案

 像这样尝试  
CREATE OR REPLACE FUNCTION truncate_schema(_schema character varying)
  RETURNS void AS
$BODY$
declare
    selectrow record;
begin
for selectrow in
select 'TRUNCATE TABLE ' || quote_ident(_schema) || '.' ||quote_ident(t.table_name) || ' CASCADE;' as qry 
from (
     SELECT table_name 
     FROM information_schema.tables
     WHERE table_type = 'BASE TABLE' AND table_schema = _schema
     )t
loop
execute selectrow.qry;
end loop;
end;
$BODY$
  LANGUAGE plpgsql

try like this 
CREATE OR REPLACE FUNCTION truncate_schema(_schema character varying)
  RETURNS void AS
$BODY$
declare
    selectrow record;
begin
for selectrow in
select 'TRUNCATE TABLE ' || quote_ident(_schema) || '.' ||quote_ident(t.table_name) || ' CASCADE;' as qry 
from (
     SELECT table_name 
     FROM information_schema.tables
     WHERE table_type = 'BASE TABLE' AND table_schema = _schema
     )t
loop
execute selectrow.qry;
end loop;
end;
$BODY$
  LANGUAGE plpgsql

使用未知字符串的String.matches使用“Unclosed count closure”(“Unclosed counted closure” with String.matches using unknown strings)

最满意答案

相关问答

下列中不属于面向对象的编程语言的是?[2022-05-30]

列出postgresql information_schema中的所有表(List all tables in postgresql information_schema)[2023-01-19]

如何删除Postgresql中的所有表而不是该模式？(How do I remove all tables and not the schema in Postgresql?)[2023-07-26]

Postgresql - 如何在具有相同模式的多个表上运行查询(Postgresql - how to run a query on multiple tables with same schema)[2021-09-28]

为什么PostgreSQL的\ dt仅显示公共模式表？(Why does PostgreSQL's \dt show only public schema tables?)[2021-11-12]

在PostgreSQL模式中列出表(List tables in a PostgreSQL schema)[2023-06-15]

在PostgreSQL中截断模式中的所有表[重复](Truncating all the tables in a schema in PostgreSQL [duplicate])[2023-08-29]

PostgreSQL中的'Schema'是什么？(What is a 'Schema' in PostgreSQL? [closed])[2023-04-29]

在Django中指定PostgreSQL Schema(Specify PostgreSQL Schema in Django)[2023-07-18]

为什么我使用这些postgresql时态数据库模式和查询获取重复行？(Why am I getting duplicate rows with these postgresql temporal db schema & queries?)[2022-03-09]

相关文章

最新问答