Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eJhJq-00075P-M3 for pgsql-hackers@arkaria.postgresql.org; Tue, 28 Nov 2017 14:57:06 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eJhJq-0007XU-4i for pgsql-hackers@arkaria.postgresql.org; Tue, 28 Nov 2017 14:57:06 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1eJhJp-0007XK-Th for pgsql-hackers@lists.postgresql.org; Tue, 28 Nov 2017 14:57:05 +0000 Received: from mail.postgrespro.ru ([93.174.131.138]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1eJhJm-0003ep-NL for pgsql-hackers@postgresql.org; Tue, 28 Nov 2017 14:57:05 +0000 Received: from localhost (localhost [127.0.0.1]) by mail.postgrespro.ru (Postfix) with ESMTP id E6C2D21C176B; Tue, 28 Nov 2017 17:57:00 +0300 (MSK) X-Virus-Scanned: Debian amavisd-new at postgrespro.ru Received: from localhost (gw.postgrespro.ru [93.174.131.141]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client did not present a certificate) by mail.postgrespro.ru (Postfix) with ESMTPSA id A167D21C0644; Tue, 28 Nov 2017 17:57:00 +0300 (MSK) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=postgrespro.ru; s=mail; t=1511881020; bh=Z3NhD2m0zosKHIecqGRx8FjnKrGLE9um0Qd0xPBtxBM=; h=Date:From:To:Cc:Subject:References:In-Reply-To; b=jn7rHYBjINqvCxGhz6xD3CunF0BOwWIlmJlAmAwQMVERNSkI8MCmKsbqptcIlXR+Y UYsptTjmz/zStRTPkQA18uXzLiULjthPujl5c/C1IMVJSQXafT4kESBbOj1feIHoGD phN8m5u4VezCY/TWJsdrrY/pJ2O0doIqooRwj4Qw= Date: Tue, 28 Nov 2017 17:57:00 +0300 From: Aleksander Alekseev To: pgsql-hackers@postgresql.org Cc: Victor Drobny Subject: Re: new function for tsquery creartion Message-ID: <20171128145659.GA32487@e733.localdomain> References: <15517a04afd2be779e2e6d69611c348b@postgrespro.ru> <20171128143916.1377.5847.pgcf@coridan.postgresql.org> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="opJtzjQTFsWo+cga" Content-Disposition: inline In-Reply-To: <20171128143916.1377.5847.pgcf@coridan.postgresql.org> User-Agent: Mutt/1.9.1 (2017-09-22) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --opJtzjQTFsWo+cga Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Hi Victor, > I like the idea and I think it's a great patch. However in current shape = it > requires some amount of reworking to meet PostgreSQL standards of code qu= ality. Also I would like to add that I agree with Thomas Munro: > Calling this search syntax just "query" seems too general and > overloaded. "Simple search", "simple query", "web search", "web > syntax", "web query", "Google-style query", "Poogle" (kidding!) ... > well I'm not sure, but I feel like it deserves a proper name. > websearch_to_tsquery()? websearch_to_tsquery() sounds much better than query_to_tsquery(). Also I agree Tomas Vondra in regard that: > 2) I don't think we should mention Google in the docs explicitly. Not > that I'm somehow anti-google, but this syntax was certainly not invented > by Google - I vividly remember using something like that on Altavista > (yeah, I'm old). And it's used by pretty much every other web search > engine out there ... I suggest to rephrase: ``` + about its input. queryto_tsquery provides a=20 + different, Google like syntax to create tsquery. ``` =2E. to something more like "provides a different syntax, similar to one used in web search engines, to create tsqeury". And maybe give a few examples right in the next sentence. --=20 Best regards, Aleksander Alekseev --opJtzjQTFsWo+cga Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCAAdFiEECAokn0QZCoIHW4GpEEnCBLXCDtYFAlodeTkACgkQEEnCBLXC DtZeVA/+MpxIL8csIpFjBXBIppfNwCFlVhQcjjSeN24DtjMY3kJdZN72Q5LLd++O d9PGSIBzRKM/Gsa38TRkFVMAUT/MC3g7Es8UsaOx+38aSXsrLpvQWpNd+ST/NOJa 8e8kVaPW4c3217lH0dnGnYC2xqaEF5R8QgvWRjNlb8m1FLMjFkFFu1SO+9hAVVGB iKsDhJFBEZ5v8fmnDOu2vMkvfUMcMfyhVKP2PeWSxcfUqQzw4++daEcrEgaAb9RH LmzW6RjPEFnMn+n4evcXllQQReQbUwhLAEJKuuA+lsYqzjQVhA9oqaFLpCXKXqNO NEowOJ3dJqwNThL2GttX2wXQ612Xjz6QF+AoH3X5zQRvhmUzRW1Ci89XGjJ0Rizb 5YJb/4wizvNhN66FQBw95G66+xKnztcrR89zhtZkgcugd/IqzDLAvT0tUkeknNoR +PpqDg5KxPLtNH3mgTXsPkphksYxswHyX74wETZinmQ2nq8BNrNvWKaJPtnH0+// bVFhhQi2WN96LVGH9FC+3jgcm3pX6D85lgEFYdntW/uyAqFBoo4JN4N3IuzTJxYB uz+v0BKyYTKJWEiSCdDSDl+d8BY3Yc//p7qKSaa4QyutBk1hg340NXjRj+6Qz59b vzfOjdYZkjkQVhPLeVZwHo07uGDWKpb0t079vdTmwHkq/U9yjto= =K0OA -----END PGP SIGNATURE----- --opJtzjQTFsWo+cga--