t_wの輪郭

RSS

WITH CTE Recursive Queries

WITH RECURSIVE

2024/8/24 8:42:00

WITH RECURSIVE hoge AS MATERIALIZED あれ『How to Use a Common Table Expression (CTE) in SQL | Timescale』あれ

WITH RECURSIVE MATERIALIZED

WITH RECURSIVE hoge AS MATERIALIZED

2024/9/29 14:31:00

WITH RECURSIVE time_weight()time_bucket()MATERIALIZED WITH hoge AS MATERIALIZED AS MATERIALIZED WITH CTE Common Table Expression Recursive Queries

『How to Use a Common Table Expression (CTE) in SQL | Timescale』

2024/8/24 8:38:00

https://www.timescale.com/learn/how-to-use-common-table-expression-sql

WITH RECURSIVE hoge AS MATERIALIZED SQLで分かち書き『towasys/tw_skk_server』MATERIALIZED WITH RECURSIVE あれ

あれ

2024/9/29 16:09:00

SKKサーバーに文節機能つけたろｗｗｗｗｗ

SQLで分かち書きしたろｗｗｗｗｗ

WITH RECURSIVE hoge AS MATERIALIZED濫用部になってる。

「SQLで分かち書きしようとする人、全員バカです」になってる。大変すぎる。

WITH RECURSIVE SQLで分かち書き

あれ

2024/9/29 16:35:00

こいつを実行するとな、

WITH RECURSIVE
	given AS NOT MATERIALIZED (
		SELECT ? as text
	),
	token AS MATERIALIZED (
		SELECT
			LENGTH(given.text) AS tail,
			0 as head,
			RIGHT(LEFT(given.text, tail-head), tail) AS chunk,
		FROM
			given
		
		UNION

		SELECT
			token.tail - 1 AS tail,
			0 as head,
			RIGHT(LEFT(token.chunk, tail-head), tail) AS chunk,
		FROM
			token
		WHERE
			tail > 0

	)
SELECT * FROM token;

こうなるんじゃ

[
  {
    tail: 4n,
    head: 0,
    chunk: "test",
  }, {
    tail: 3n,
    head: 0,
    chunk: "test",
  }, {
    tail: 2n,
    head: 0,
    chunk: "tes",
  }, {
    tail: 1n,
    head: 0,
    chunk: "te",
  }, {
    tail: 0n,
    head: 0,
    chunk: "t",
  }
]

素直にプログラミング言語でfor文をまわす方が簡単じゃな。