Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/postgis-workshop/simple_sql/uk/units/?format=api
{ "count": 34, "next": null, "previous": null, "results": [ { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/uk/?format=api", "source": [ "Simple SQL" ], "previous_source": "", "target": [ "" ], "id_hash": 3260372505424773931, "content_hash": 3260372505424773931, "location": "../../en/simple_sql.rst:4", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://weblate.osgeo.org/api/units/99017/?format=api", "priority": 100, "id": 2360757, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/uk/?checksum=ad3f2b84fd4b432b", "url": "https://weblate.osgeo.org/api/units/2360757/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-13T16:16:06.466606Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/uk/?format=api", "source": [ ":term:`SQL`, or \"Structured Query Language\", is a means of asking questions of, and updating data in, relational databases. You have already seen SQL when we created our first database. Recall:" ], "previous_source": "", "target": [ "" ], "id_hash": 6109885188356942522, "content_hash": 6109885188356942522, "location": "../../en/simple_sql.rst:6", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 30, "source_unit": "https://weblate.osgeo.org/api/units/99030/?format=api", "priority": 100, "id": 2360758, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/uk/?checksum=d4caac350e6faaba", "url": "https://weblate.osgeo.org/api/units/2360758/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-13T16:16:06.501762Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/uk/?format=api", "source": [ "But that was a question about the database. Now that we've loaded data into our database, let's use SQL to ask questions of the data! For example," ], "previous_source": "", "target": [ "" ], "id_hash": 3420781391977058570, "content_hash": 3420781391977058570, "location": "../../en/simple_sql.rst:12", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 3, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 27, "source_unit": "https://weblate.osgeo.org/api/units/99032/?format=api", "priority": 100, "id": 2360759, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/uk/?checksum=af790e8d4b0f110a", "url": "https://weblate.osgeo.org/api/units/2360759/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-13T16:16:06.504680Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/uk/?format=api", "source": [ "\"What are the names of all the neighborhoods in New York City?\"" ], "previous_source": "", "target": [ "" ], "id_hash": -1624571585063872884, "content_hash": -1624571585063872884, "location": "../../en/simple_sql.rst:14", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://weblate.osgeo.org/api/units/99034/?format=api", "priority": 100, "id": 2360760, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/uk/?checksum=69745cc03013168c", "url": "https://weblate.osgeo.org/api/units/2360760/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-13T16:16:06.507304Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/uk/?format=api", "source": [ "Open up the SQL query window in pgAdmin by clicking the \"Query Tool\" button." ], "previous_source": "", "target": [ "" ], "id_hash": -907009057047372689, "content_hash": -907009057047372689, "location": "../../en/simple_sql.rst:16", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 5, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://weblate.osgeo.org/api/units/99036/?format=api", "priority": 100, "id": 2360761, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/uk/?checksum=7369a81172a11c6f", "url": "https://weblate.osgeo.org/api/units/2360761/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-13T16:16:06.534260Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/uk/?format=api", "source": [ "then enter the following query in to the query window" ], "previous_source": "", "target": [ "" ], "id_hash": -2023684897651416972, "content_hash": -2023684897651416972, "location": "../../en/simple_sql.rst:20", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://weblate.osgeo.org/api/units/99038/?format=api", "priority": 100, "id": 2360762, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/uk/?checksum=63ea6d4eba2a2074", "url": "https://weblate.osgeo.org/api/units/2360762/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-13T16:16:06.536864Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/uk/?format=api", "source": [ "and click the **Execute Query** button (the green triangle)." ], "previous_source": "", "target": [ "" ], "id_hash": -7293482142959842860, "content_hash": -7293482142959842860, "location": "../../en/simple_sql.rst:26", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://weblate.osgeo.org/api/units/99040/?format=api", "priority": 100, "id": 2360763, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/uk/?checksum=1ac858a22d3949d4", "url": "https://weblate.osgeo.org/api/units/2360763/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-13T16:16:06.549756Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/uk/?format=api", "source": [ "The query will run for a few (milli)seconds and return the 129 results." ], "previous_source": "", "target": [ "" ], "id_hash": 6173238359614649658, "content_hash": 6173238359614649658, "location": "../../en/simple_sql.rst:30", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 8, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://weblate.osgeo.org/api/units/99042/?format=api", "priority": 100, "id": 2360764, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/uk/?checksum=d5abbf94b2a5753a", "url": "https://weblate.osgeo.org/api/units/2360764/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-13T16:16:06.552233Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/uk/?format=api", "source": [ "But what exactly happened here? To understand, let's begin with the four \"verbs\" of SQL," ], "previous_source": "", "target": [ "" ], "id_hash": -4127000444081064219, "content_hash": -4127000444081064219, "location": "../../en/simple_sql.rst:35", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 9, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://weblate.osgeo.org/api/units/99044/?format=api", "priority": 100, "id": 2360765, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/uk/?checksum=46b9f2f63eab36e5", "url": "https://weblate.osgeo.org/api/units/2360765/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-13T16:16:06.555058Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/uk/?format=api", "source": [ "``SELECT``, returns rows in response to a query" ], "previous_source": "", "target": [ "" ], "id_hash": -6660562141957401108, "content_hash": -6660562141957401108, "location": "../../en/simple_sql.rst:37", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 10, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://weblate.osgeo.org/api/units/99046/?format=api", "priority": 100, "id": 2360766, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/uk/?checksum=2390ee056436d5ec", "url": "https://weblate.osgeo.org/api/units/2360766/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-13T16:16:06.557780Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/uk/?format=api", "source": [ "``INSERT``, adds new rows to a table" ], "previous_source": "", "target": [ "" ], "id_hash": 9192180302915813808, "content_hash": 9192180302915813808, "location": "../../en/simple_sql.rst:38", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 11, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://weblate.osgeo.org/api/units/99048/?format=api", "priority": 100, "id": 2360767, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/uk/?checksum=ff912f4882a3c1b0", "url": "https://weblate.osgeo.org/api/units/2360767/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-13T16:16:06.560255Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/uk/?format=api", "source": [ "``UPDATE``, alters existing rows in a table" ], "previous_source": "", "target": [ "" ], "id_hash": 4219466802024757162, "content_hash": 4219466802024757162, "location": "../../en/simple_sql.rst:39", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 12, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://weblate.osgeo.org/api/units/99050/?format=api", "priority": 100, "id": 2360768, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/uk/?checksum=ba8e8eb3643d37aa", "url": "https://weblate.osgeo.org/api/units/2360768/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-13T16:16:06.562650Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/uk/?format=api", "source": [ "``DELETE``, removes rows from a table" ], "previous_source": "", "target": [ "" ], "id_hash": -485321283411790201, "content_hash": -485321283411790201, "location": "../../en/simple_sql.rst:40", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 13, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://weblate.osgeo.org/api/units/99052/?format=api", "priority": 100, "id": 2360769, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/uk/?checksum=7943cadd344db687", "url": "https://weblate.osgeo.org/api/units/2360769/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-13T16:16:06.565169Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/uk/?format=api", "source": [ "We will be working almost exclusively with ``SELECT`` in order to ask questions of tables using spatial functions." ], "previous_source": "", "target": [ "" ], "id_hash": -7357759092566018791, "content_hash": -7357759092566018791, "location": "../../en/simple_sql.rst:42", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 14, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://weblate.osgeo.org/api/units/99055/?format=api", "priority": 100, "id": 2360770, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/uk/?checksum=19e3fd16a0b3b519", "url": "https://weblate.osgeo.org/api/units/2360770/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-13T16:16:06.576319Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/uk/?format=api", "source": [ "SELECT queries" ], "previous_source": "", "target": [ "" ], "id_hash": -3824971344125347342, "content_hash": -3824971344125347342, "location": "../../en/simple_sql.rst:45", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 15, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://weblate.osgeo.org/api/units/99057/?format=api", "priority": 100, "id": 2360771, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/uk/?checksum=4aeaf8d3fd5c39f2", "url": "https://weblate.osgeo.org/api/units/2360771/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-13T16:16:06.578976Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/uk/?format=api", "source": [ "A select query is generally of the form::" ], "previous_source": "", "target": [ "" ], "id_hash": 2154556753285362955, "content_hash": 2154556753285362955, "location": "../../en/simple_sql.rst:47", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 16, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://weblate.osgeo.org/api/units/99060/?format=api", "priority": 100, "id": 2360772, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/uk/?checksum=9de685f3a7fe350b", "url": "https://weblate.osgeo.org/api/units/2360772/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-13T16:16:06.581467Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/uk/?format=api", "source": [ "For a synopsis of all ``SELECT`` parameters, see the `PostgresSQL documentation <http://www.postgresql.org/docs/current/interactive/sql-select.html>`_." ], "previous_source": "", "target": [ "" ], "id_hash": -1510787613949988140, "content_hash": -1510787613949988140, "location": "../../en/simple_sql.rst:53", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 17, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://weblate.osgeo.org/api/units/99063/?format=api", "priority": 100, "id": 2360773, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/uk/?checksum=6b089aab6b7372d4", "url": "https://weblate.osgeo.org/api/units/2360773/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-13T16:16:06.584055Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/uk/?format=api", "source": [ "The ``some_columns`` are either column names or functions of column values. The ``some_data_source`` is either a single table, or a composite table created by joining two tables on a key or condition. The ``some_condition`` is a filter that restricts the number of rows to be returned." ], "previous_source": "", "target": [ "" ], "id_hash": 1653121983106668767, "content_hash": 1653121983106668767, "location": "../../en/simple_sql.rst:55", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 18, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 46, "source_unit": "https://weblate.osgeo.org/api/units/99066/?format=api", "priority": 100, "id": 2360774, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/uk/?checksum=96f111af5d7658df", "url": "https://weblate.osgeo.org/api/units/2360774/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-13T16:16:06.586720Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/uk/?format=api", "source": [ "\"What are the names of all the neighborhoods in Brooklyn?\"" ], "previous_source": "", "target": [ "" ], "id_hash": 6187990933837514987, "content_hash": 6187990933837514987, "location": "../../en/simple_sql.rst:57", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 19, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://weblate.osgeo.org/api/units/99069/?format=api", "priority": 100, "id": 2360775, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/uk/?checksum=d5e028f80cb908eb", "url": "https://weblate.osgeo.org/api/units/2360775/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-13T16:16:06.589357Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/uk/?format=api", "source": [ "We return to our ``nyc_neighborhoods`` table with a filter in hand. The table contains all the neighborhoods in New York, but we only want the ones in Brooklyn." ], "previous_source": "", "target": [ "" ], "id_hash": -943566596679662443, "content_hash": -943566596679662443, "location": "../../en/simple_sql.rst:59", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 20, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://weblate.osgeo.org/api/units/99072/?format=api", "priority": 100, "id": 2360776, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/uk/?checksum=72e7c72df6fc0495", "url": "https://weblate.osgeo.org/api/units/2360776/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-13T16:16:06.591867Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/uk/?format=api", "source": [ "The query will run for even fewer (milli)seconds and return the 23 results." ], "previous_source": "", "target": [ "" ], "id_hash": -1483977016853120188, "content_hash": -1483977016853120188, "location": "../../en/simple_sql.rst:67", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 21, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://weblate.osgeo.org/api/units/99074/?format=api", "priority": 100, "id": 2360777, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/uk/?checksum=6b67dac3ffa03b44", "url": "https://weblate.osgeo.org/api/units/2360777/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-13T16:16:06.594405Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/uk/?format=api", "source": [ "Sometimes we will need to apply a function to the results of our query. For example," ], "previous_source": "", "target": [ "" ], "id_hash": -8830976247187079690, "content_hash": -8830976247187079690, "location": "../../en/simple_sql.rst:69", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 22, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://weblate.osgeo.org/api/units/99076/?format=api", "priority": 100, "id": 2360778, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/uk/?checksum=057211e446807df6", "url": "https://weblate.osgeo.org/api/units/2360778/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-13T16:16:06.596942Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/uk/?format=api", "source": [ "\"What is the number of letters in the names of all the neighborhoods in Brooklyn?\"" ], "previous_source": "", "target": [ "" ], "id_hash": 197458882924291075, "content_hash": 197458882924291075, "location": "../../en/simple_sql.rst:71", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 23, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://weblate.osgeo.org/api/units/99078/?format=api", "priority": 100, "id": 2360779, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/uk/?checksum=82bd83cece72a403", "url": "https://weblate.osgeo.org/api/units/2360779/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-13T16:16:06.599498Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/uk/?format=api", "source": [ "Fortunately, PostgreSQL has a string length function, :command:`char_length(string)`." ], "previous_source": "", "target": [ "" ], "id_hash": 8605128158431623754, "content_hash": 8605128158431623754, "location": "../../en/simple_sql.rst:73", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 24, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://weblate.osgeo.org/api/units/99081/?format=api", "priority": 100, "id": 2360780, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/uk/?checksum=f76b8e77da073a4a", "url": "https://weblate.osgeo.org/api/units/2360780/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-13T16:16:06.601972Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/uk/?format=api", "source": [ "Often, we are less interested in the individual rows than in a statistic that applies to all of them. So knowing the lengths of the neighborhood names might be less interesting than knowing the average length of the names. Functions that take in multiple rows and return a single result are called \"aggregate\" functions." ], "previous_source": "", "target": [ "" ], "id_hash": -1600117973108927706, "content_hash": -1600117973108927706, "location": "../../en/simple_sql.rst:81", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 25, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 54, "source_unit": "https://weblate.osgeo.org/api/units/99083/?format=api", "priority": 100, "id": 2360781, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/uk/?checksum=69cb3d2e661fd326", "url": "https://weblate.osgeo.org/api/units/2360781/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-13T16:16:06.604400Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/uk/?format=api", "source": [ "PostgreSQL has a series of built-in aggregate functions, including the general purpose :command:`avg()` for average values and :command:`stddev()` for standard deviations." ], "previous_source": "", "target": [ "" ], "id_hash": 3994244424292428431, "content_hash": 3994244424292428431, "location": "../../en/simple_sql.rst:83", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 26, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://weblate.osgeo.org/api/units/99086/?format=api", "priority": 100, "id": 2360782, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/uk/?checksum=b76e68243808ea8f", "url": "https://weblate.osgeo.org/api/units/2360782/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-13T16:16:06.606985Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/uk/?format=api", "source": [ "\"What is the average number of letters and standard deviation of number of letters in the names of all the neighborhoods in Brooklyn?\"" ], "previous_source": "", "target": [ "" ], "id_hash": 5702891689831228540, "content_hash": 5702891689831228540, "location": "../../en/simple_sql.rst:85", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 27, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 23, "source_unit": "https://weblate.osgeo.org/api/units/99089/?format=api", "priority": 100, "id": 2360783, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/uk/?checksum=cf24bdc6d4eae47c", "url": "https://weblate.osgeo.org/api/units/2360783/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-13T16:16:06.609508Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/uk/?format=api", "source": [ "The aggregate functions in our last example were applied to every row in the result set. What if we want the summaries to be carried out over smaller groups within the overall result set? For that we add a ``GROUP BY`` clause. Aggregate functions often need an added ``GROUP BY`` statement to group the result-set by one or more columns." ], "previous_source": "", "target": [ "" ], "id_hash": 2393826065730826252, "content_hash": 2393826065730826252, "location": "../../en/simple_sql.rst:99", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 28, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 60, "source_unit": "https://weblate.osgeo.org/api/units/99092/?format=api", "priority": 100, "id": 2360784, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/uk/?checksum=a138941fadf4f00c", "url": "https://weblate.osgeo.org/api/units/2360784/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-13T16:16:06.617995Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/uk/?format=api", "source": [ "\"What is the average number of letters in the names of all the neighborhoods in New York City, reported by borough?\"" ], "previous_source": "", "target": [ "" ], "id_hash": -4676956579218002815, "content_hash": -4676956579218002815, "location": "../../en/simple_sql.rst:101", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 29, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://weblate.osgeo.org/api/units/99095/?format=api", "priority": 100, "id": 2360785, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/uk/?checksum=3f181cc551c8ec81", "url": "https://weblate.osgeo.org/api/units/2360785/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-13T16:16:06.620676Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/uk/?format=api", "source": [ "We include the ``boroname`` column in the output result so we can determine which statistic applies to which borough. In an aggregate query, you can only output columns that are either (a) members of the grouping clause or (b) aggregate functions." ], "previous_source": "", "target": [ "" ], "id_hash": 4597163752082972764, "content_hash": 4597163752082972764, "location": "../../en/simple_sql.rst:109", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 30, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 41, "source_unit": "https://weblate.osgeo.org/api/units/99099/?format=api", "priority": 100, "id": 2360786, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/uk/?checksum=bfcc68136135205c", "url": "https://weblate.osgeo.org/api/units/2360786/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-13T16:16:06.623309Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/uk/?format=api", "source": [ "Function List" ], "previous_source": "", "target": [ "" ], "id_hash": 2815949782297668712, "content_hash": 2815949782297668712, "location": "../../en/simple_sql.rst:122", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 31, "has_suggestion": true, "has_comment": false, "has_failing_check": true, "num_words": 2, "source_unit": "https://weblate.osgeo.org/api/units/99103/?format=api", "priority": 100, "id": 2360787, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/uk/?checksum=a71443684f30ec68", "url": "https://weblate.osgeo.org/api/units/2360787/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-13T16:16:06.625862Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/uk/?format=api", "source": [ "`avg(expression) <http://www.postgresql.org/docs/current/static/functions-aggregate.html#FUNCTIONS-AGGREGATE-TABLE>`_: PostgreSQL aggregate function that returns the average value of a numeric column." ], "previous_source": "", "target": [ "" ], "id_hash": -5033877154090146436, "content_hash": -5033877154090146436, "location": "../../en/simple_sql.rst:124", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 32, "has_suggestion": true, "has_comment": false, "has_failing_check": true, "num_words": 14, "source_unit": "https://weblate.osgeo.org/api/units/99107/?format=api", "priority": 100, "id": 2360788, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/uk/?checksum=3a2413662380a57c", "url": "https://weblate.osgeo.org/api/units/2360788/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-13T16:16:06.628347Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/uk/?format=api", "source": [ "`char_length(string) <http://www.postgresql.org/docs/current/static/functions-string.html>`_: PostgreSQL string function that returns the number of character in a string." ], "previous_source": "", "target": [ "" ], "id_hash": -5151420096834902630, "content_hash": -5151420096834902630, "location": "../../en/simple_sql.rst:126", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 33, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://weblate.osgeo.org/api/units/99110/?format=api", "priority": 100, "id": 2360789, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/uk/?checksum=38827ab71f58e59a", "url": "https://weblate.osgeo.org/api/units/2360789/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-13T16:16:06.630846Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/uk/?format=api", "source": [ "`stddev(expression) <http://www.postgresql.org/docs/current/static/functions-aggregate.html#FUNCTIONS-AGGREGATE-STATISTICS-TABLE>`_: PostgreSQL aggregate function that returns the standard deviation of input values." ], "previous_source": "", "target": [ "" ], "id_hash": -7822121017709672541, "content_hash": -7822121017709672541, "location": "../../en/simple_sql.rst:128", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 34, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://weblate.osgeo.org/api/units/99113/?format=api", "priority": 100, "id": 2360790, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/uk/?checksum=13723e60b54c47a3", "url": "https://weblate.osgeo.org/api/units/2360790/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-13T16:16:06.633315Z" } ] }