Changes
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/postgis-workshop/simple_sql/ja/changes/?format=api
{ "count": 117, "next": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/changes/?format=api&page=2", "previous": null, "results": [ { "unit": null, "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": null, "author": null, "timestamp": "2024-02-27T02:45:21.048071Z", "action": 17, "target": "", "id": 1949037, "action_name": "Changes committed", "url": "https://weblate.osgeo.org/api/changes/1949037/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99358/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2024-02-27T02:08:21.773765Z", "action": 7, "target": "「ニューヨーク市の、行政区ごとの地区の名前の文字数の平均値を知りたい」", "id": 1948986, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1948986/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99355/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2024-02-27T02:08:19.167539Z", "action": 7, "target": "「ブルックリンの全地区の名前の文字数の平均値と標準偏差を知りたい」", "id": 1948985, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1948985/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99353/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2024-02-27T02:08:16.129457Z", "action": 7, "target": "私たちはしばしば、結果の個々の行よりも、全体の統計値の方に興味を持ちます。ここで、地区ごとの名前の長さを知ることより、地区名の長さの平均値の方に興味を持っているとします。ここで使う関数は複数の行を引数に取り、単一の結果を返すもので、「集約」関数と呼ばれます。", "id": 1948984, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1948984/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99351/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2024-02-27T02:08:11.252753Z", "action": 7, "target": "「ブルックリンの全ての地区の名前の文字数を知りたい」", "id": 1948983, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1948983/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99346/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2024-02-27T02:08:09.079414Z", "action": 7, "target": "「ブルックリンの全ての地区の名前を知りたい」", "id": 1948982, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1948982/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99329/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2024-02-27T02:08:06.540478Z", "action": 7, "target": "「ニューヨーク市内の全ての地区の名前を知りたい」", "id": 1948981, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1948981/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99358/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2024-02-27T02:07:57.655295Z", "action": 4, "target": "「ニューヨーク市の、行政区ごとの地区の名前の文字数の平均値を知りたい」", "id": 1948980, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1948980/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99355/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2024-02-27T02:07:57.648839Z", "action": 4, "target": "「ブルックリンの全地区の名前の文字数の平均値と標準偏差を知りたい」", "id": 1948979, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1948979/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99353/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2024-02-27T02:07:57.640725Z", "action": 4, "target": "私たちはしばしば、結果の個々の行よりも、全体の統計値の方に興味を持ちます。ここで、地区ごとの名前の長さを知ることより、地区名の長さの平均値の方に興味を持っているとします。ここで使う関数は複数の行を引数に取り、単一の結果を返すもので、「集約」関数と呼ばれます。", "id": 1948978, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1948978/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99351/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2024-02-27T02:07:57.627563Z", "action": 4, "target": "「ブルックリンの全ての地区の名前の文字数を知りたい」", "id": 1948977, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1948977/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99346/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2024-02-27T02:07:57.614901Z", "action": 4, "target": "「ブルックリンの全ての地区の名前を知りたい」", "id": 1948976, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1948976/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99329/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2024-02-27T02:07:57.598642Z", "action": 4, "target": "「ニューヨーク市内の全ての地区の名前を知りたい」", "id": 1948975, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1948975/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99358/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2024-02-27T02:06:07.879285Z", "action": 7, "target": "「ニューヨーク市の、行政区ごとの地域の名前の文字数の平均値を知りたい」", "id": 1948974, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1948974/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99355/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2024-02-27T02:06:04.555313Z", "action": 7, "target": "「ブルックリンの全地域の名前の文字数の平均値と標準偏差を知りたい」", "id": 1948973, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1948973/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99353/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2024-02-27T02:06:01.308280Z", "action": 7, "target": "私たちはしばしば、結果の個々の行よりも、全体の統計値の方に興味を持ちます。ここで、地区ごとの名前の長さを知ることより、地域名の長さの平均値の方に興味を持っているとします。ここで使う関数は複数の行を引数に取り、単一の結果を返すもので、「集約」関数と呼ばれます。", "id": 1948972, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1948972/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99351/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2024-02-27T02:05:55.548177Z", "action": 7, "target": "「ブルックリンの全ての地域の名前の文字数を知りたい」", "id": 1948971, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1948971/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99346/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2024-02-27T02:05:52.942807Z", "action": 7, "target": "「ブルックリンの全ての地域の名前を知りたい」", "id": 1948970, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1948970/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99329/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2024-02-27T02:05:49.422274Z", "action": 7, "target": "「ニューヨーク市内の全ての地域の名前を知りたい」", "id": 1948969, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1948969/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99358/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2024-02-27T02:05:41.015315Z", "action": 4, "target": "「ニューヨーク市の、行政区ごとの地域の名前の文字数の平均値を知りたい」", "id": 1948968, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1948968/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99355/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2024-02-27T02:05:41.002758Z", "action": 4, "target": "「ブルックリンの全地域の名前の文字数の平均値と標準偏差を知りたい」", "id": 1948967, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1948967/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99353/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2024-02-27T02:05:40.994107Z", "action": 4, "target": "私たちはしばしば、結果の個々の行よりも、全体の統計値の方に興味を持ちます。ここで、地区ごとの名前の長さを知ることより、地域名の長さの平均値の方に興味を持っているとします。ここで使う関数は複数の行を引数に取り、単一の結果を返すもので、「集約」関数と呼ばれます。", "id": 1948966, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1948966/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99351/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2024-02-27T02:05:40.985546Z", "action": 4, "target": "「ブルックリンの全ての地域の名前の文字数を知りたい」", "id": 1948965, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1948965/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99346/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2024-02-27T02:05:40.977196Z", "action": 4, "target": "「ブルックリンの全ての地域の名前を知りたい」", "id": 1948964, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1948964/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99329/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2024-02-27T02:05:40.960801Z", "action": 4, "target": "「ニューヨーク市内の全ての地域の名前を知りたい」", "id": 1948963, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1948963/?format=api" }, { "unit": null, "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": null, "author": null, "timestamp": "2023-12-05T03:23:49.511753Z", "action": 17, "target": "", "id": 1899910, "action_name": "Changes committed", "url": "https://weblate.osgeo.org/api/changes/1899910/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99328/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-04T06:42:50.615995Z", "action": 2, "target": "これはデータベースに関する問合せでした。現時点では既にデータをロードしています。SQL でデータの問合せを実行してみましょう! たとえば、", "id": 1899909, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/1899909/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99341/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-04T03:05:13.315046Z", "action": 26, "target": "空間関数を使うテーブルの問い合わせでは、使うのはほとんど \"SELECT\" だけになります。", "id": 1899908, "action_name": "Suggestion removed", "url": "https://weblate.osgeo.org/api/changes/1899908/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99328/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-04T03:05:07.391112Z", "action": 26, "target": "これはデータベースに関する問い合わせでした。現時点では既にデータをロードしています。SQL でデータの問い合わせを実行してみましょう! 例を示します:", "id": 1899907, "action_name": "Suggestion removed", "url": "https://weblate.osgeo.org/api/changes/1899907/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99327/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-04T03:04:59.423405Z", "action": 26, "target": ":term:`SQL` (\"Structured Query Language\") は、リレーショナルデータベースにおいて、問い合わせ、更新を行う手段です。データベースの生成の地点で、みなさんは既に SQL を見ています。思い返してみましょう:", "id": 1899906, "action_name": "Suggestion removed", "url": "https://weblate.osgeo.org/api/changes/1899906/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99364/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-04T03:04:38.229481Z", "action": 7, "target": "`avg(expression) <https://www.postgresql.jp/document/current/html/functions-aggregate.html#FUNCTIONS-AGGREGATE-STATISTICS-TABLE>`_: 入力値の標準偏差を返す PostgreSQL 集約関数。", "id": 1899905, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1899905/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99363/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-04T03:04:34.898766Z", "action": 7, "target": "`char_length(string) <https://www.postgresql.jp/document/current/html/functions-string.html>`_: 文字列の文字数を返すPostgreSQL 文字列関数。", "id": 1899904, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1899904/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99361/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-04T03:04:32.087568Z", "action": 7, "target": "`avg(expression) <https://www.postgresql.jp/document/current/html/functions-aggregate.html#FUNCTIONS-AGGREGATE-TABLE>`_: 数値カラムの値の平均を返す PostgreSQL 集約関数。", "id": 1899903, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1899903/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99359/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-04T03:04:28.300016Z", "action": 7, "target": "出力結果に \"boroname\" (行政区名) カラムが含まれているので、どの統計がどの行政区に適用されるかの判断ができます。集約クエリでは、(a) グループ句のメンバーか、または (b) 集約関数かのカラムだけを出力できます。", "id": 1899901, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1899901/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99358/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-04T03:04:24.347600Z", "action": 7, "target": "「ニューヨーク市の、行政区ごとの地区の名前の文字数の平均値を知りたい」", "id": 1899900, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1899900/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99357/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-04T03:04:19.522720Z", "action": 7, "target": "最後の例での集約関数は、結果集合の全ての行に適用されました。もし結果集合全体をより小さなグループにして集計を実行したい場合には、どうするでしょうか。その場合には、\"GROUP BY\"句 を追加します。集約関数はしばしば、1以上のカラムによる結果セットのグループ化のために \"GROUP BY\"句 を追加しなければなりません。", "id": 1899899, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1899899/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99355/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-04T03:04:15.012525Z", "action": 7, "target": "「ブルックリンの全地区の名前の文字数の平均値と標準偏差を知りたい」", "id": 1899898, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1899898/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99354/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-04T03:04:12.995552Z", "action": 7, "target": "PostgrSQL は、平均値を求める :command:`avg()` や、標準偏差を求める :command:`stddev()` などといった汎用的な一連の組込集約関数を持っています。", "id": 1899897, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1899897/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99353/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-04T03:04:09.035711Z", "action": 7, "target": "私たちはしばしば、結果の個々の行よりも、全体の統計値の方に興味を持ちます。ここで、地区ごとの名前の長さを知ることより、地区名の長さの平均値の方に興味を持っているとします。ここで使う関数は複数の行を引数に取り、単一の結果を返すもので、「集約」関数と呼ばれます。", "id": 1899896, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1899896/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99352/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-04T03:04:04.826966Z", "action": 7, "target": "幸運なことに、PostgreSQL には、文字列長を得る :command:`char_length(string)`. という関数があります。", "id": 1899895, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1899895/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99351/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-04T03:04:01.640754Z", "action": 7, "target": "「ブルックリンの全ての地区の名前の文字数を知りたい」", "id": 1899894, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1899894/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99350/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-04T03:03:57.873963Z", "action": 7, "target": "時々、関数をクエリの結果に適用する必要があります。例を挙げます、", "id": 1899893, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1899893/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99349/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-04T03:03:46.684317Z", "action": 2, "target": "クエリは、さらに短く、数秒 (数ミリ秒) で終わり、23件の結果を返します。", "id": 1899892, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/1899892/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99349/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-04T03:02:58.087969Z", "action": 7, "target": "クエリは、さらに短く、数 (ミリ) 秒で終わり、23件の結果を返します。", "id": 1899891, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1899891/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99348/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-04T03:02:53.185717Z", "action": 7, "target": "``nyc_neighborhoods`` テーブルに話を戻します。テーブルはニューヨーク市の全ての地区を持っていますが、ブルックリン内の地区だけを求めています。", "id": 1899890, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1899890/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99346/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-04T03:02:50.557159Z", "action": 7, "target": "「ブルックリンの全ての地区の名前を知りたい」", "id": 1899889, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1899889/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99345/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-04T03:02:46.836706Z", "action": 7, "target": "\"some_columns\" は、カラム名またはカラム値の半数のいずれかです。\"some_data_source\" は、単一のテーブルか、二つのテーブルをキーまたは条件で結合した複合テーブルです。\"some_condition\" は、返される行数を制限するフィルタです。", "id": 1899888, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1899888/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99344/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-04T03:02:40.991595Z", "action": 7, "target": "\"SELECT\" の全てのパラメータの概要については、`PostgresSQL 文書 <https://www.postgresql.jp/document/current/html/sql-select.html>`_ をご覧下さい。", "id": 1899887, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1899887/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99343/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-04T03:02:35.961157Z", "action": 7, "target": "SELECTクエリは一般的に次の形式になります:", "id": 1899886, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1899886/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99342/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-04T03:02:32.210526Z", "action": 7, "target": "SELECT クエリ", "id": 1899885, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1899885/?format=api" } ] }