Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qSJdv-005L0p-LL for pgsql-general@arkaria.postgresql.org; Sat, 05 Aug 2023 15:56:39 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qSJds-00HIyl-KR for pgsql-general@arkaria.postgresql.org; Sat, 05 Aug 2023 15:56:37 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qSJds-00HIyc-AW for pgsql-general@lists.postgresql.org; Sat, 05 Aug 2023 15:56:36 +0000 Received: from mail-pf1-x443.google.com ([2607:f8b0:4864:20::443]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qSJdp-000h4x-VQ for pgsql-general@lists.postgresql.org; Sat, 05 Aug 2023 15:56:35 +0000 Received: by mail-pf1-x443.google.com with SMTP id d2e1a72fcca58-6874a386ec7so572471b3a.1 for ; Sat, 05 Aug 2023 08:56:33 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1691250992; x=1691855792; h=to:date:message-id:subject:mime-version:content-transfer-encoding :from:from:to:cc:subject:date:message-id:reply-to; bh=3q1NeppYmJVjiVAhAQdv/Aa7HAuLMkQGNpVtOIXlT7c=; b=raOYm3NCcyC6EzDQHWr764NK+r6NPpVOTYfpvcS1qW9jd398duKeG3CM1LI1zQVKFg NiygzGT5Z3HrxMmdG+PFKk1M7OfoR8C1EvZZYszx6U5ZvSrq7wqn1ouQSRfdcQLiiJWE SVScERErrxko67RVj2Zt2SzHTU5DHwgqhXYStyjsiWYy4qWbAdfBArgoybpwlP+KUH8n dt9jB4LciJ0V2uxsxCOjwIDPnVXC3hV20rn2zF74IQEPheNHkGCJcD9M/bCYFTO74yE+ s/iRvVNXVug2VPaxxmGzHDg7gFwTZ0DJiGz6QMRbbsxAzEEjVvvwZe01hxAoa+s0MvGh lcwQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1691250992; x=1691855792; h=to:date:message-id:subject:mime-version:content-transfer-encoding :from:x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=3q1NeppYmJVjiVAhAQdv/Aa7HAuLMkQGNpVtOIXlT7c=; b=Jh2QwBGk2mIiXunDCMt5vXE9fpuiDm8MRUUlimFp4cICc7MNjwFo1eJt1IFz4AN/Jz szHOZuARqc5EbQfAUZFbs9D6oR1TIh2rsPxswnkm4TFErHNHs+mKltd1/EC32zgV0qtF kmMK6KK9bdWwXqchwEOjBgTsCANMP+MncpTifteVHNNNrdQlzgPum9y3fCfwusXZarVy jmduvEPOO4Jgl//e64tWsE/EQJ/h1MZXIBcWssmCf/mXnjhFyujYr8bVi8pOmWpKAKU7 mIX/LRzYCjtaQ0TC8nwkwaB9l1Azapn/INLudd9Efg8LGgIv7LnIJzem1xOHO7X3tTfg +hfQ== X-Gm-Message-State: ABy/qLZ+xDWTm/WyzAQEGJSzUK3JseKIPSW3CoFYY1iM3RMuPVB16Yxx 231JIFE17nJts5WZOh1jkTvWqQfBUWHD/rReRlk= X-Google-Smtp-Source: APBJJlFAhQOnmsPcmPbeOqGJrJAR7z8t2Vbt7HrTkSI5kDqjZxYuRupU2Z4BjoOGhvwjAciJhkWsog== X-Received: by 2002:a05:6a00:1951:b0:668:834d:4bd with SMTP id s17-20020a056a00195100b00668834d04bdmr23439721pfk.0.1691250992003; Sat, 05 Aug 2023 08:56:32 -0700 (PDT) Received: from smtpclient.apple ([2406:da18:56b:6600:4a76:f48e:2bbc:35d1]) by smtp.gmail.com with ESMTPSA id p26-20020a62ab1a000000b006871fdde2c7sm3302964pff.110.2023.08.05.08.56.30 for (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Sat, 05 Aug 2023 08:56:31 -0700 (PDT) From: jacktby jacktby Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3731.600.7\)) Subject: Failed to parse new syntax Message-Id: <8D78FF61-FE67-45C9-94D0-8EC7C7DFBEA5@gmail.com> Date: Sat, 5 Aug 2023 23:56:18 +0800 To: pgsql-general@lists.postgresql.org X-Mailer: Apple Mail (2.3731.600.7) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk /* * similarity_search_expr is used for our multi-mode=20 * similarity_search, and we just use this for multi * cols search. */ similarity_search_expr:=20 sub_search_expr '<' AexprConst { $$ =3D (Node *) makeSimpleA_Expr(AEXPR_OP, "<", $1, $3, = @2); } ; sub_search_expr: '[' col_tuple_expr '~' AexprConst ']' { $$ =3D (Node *) makeSimpleA_Expr(AEXPR_OP, "~", $2, $4, = @3); } ; col_tuple_expr: columnref { $$ =3D $1;} | '(' col_list_expr ')' { $$ =3D $2;} ; col_list_expr: columnref { ResTarget* target =3D makeNode(ResTarget); target->name =3D NULL; target->indirection =3D NIL; target->val =3D (Node *) $1; target->location =3D @1; $$ =3D list_make1(target); } | col_list_expr ',' columnref { $$ =3D lappend($1,$3);} ; This is my new grammer. But I get below: postgres=3D# select * from t2 where [a ~ 1] < 0; ERROR: syntax error at or near "~" LINE 1: select * from t2 where [a ~ 1] < 0; It=E2=80=99s strange that it can=E2=80=99t parse =E2=80=98~=E2=80=99, I = add it in the parser.=