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 1rWKf9-004qjb-CE for pgsql-www@arkaria.postgresql.org; Sat, 03 Feb 2024 18:22:48 +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 1rWKe9-002ezG-9d for pgsql-www@arkaria.postgresql.org; Sat, 03 Feb 2024 18:21:45 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rWKe8-002ez7-UT for pgsql-www@lists.postgresql.org; Sat, 03 Feb 2024 18:21:45 +0000 Received: from mail.postgrespro.ru ([93.174.131.139]) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rWKe0-005HyP-6R for pgsql-www@postgresql.org; Sat, 03 Feb 2024 18:21:42 +0000 Received: from [192.168.100.8] (109-252-85-96.nat.spd-mgts.ru [109.252.85.96]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (Client did not present a certificate) (Authenticated sender: a.melnikov@postgrespro.ru) by mail.postgrespro.ru (Postfix/587) with ESMTPSA id A8EFBE2112F for ; Sat, 3 Feb 2024 21:21:33 +0300 (MSK) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=postgrespro.ru; s=mx2023; t=1706984493; bh=5BJgTOhCVBWGfFuTUr/b2pjgal0kg22Wdm6uyy8u7nY=; h=Message-ID:Date:User-Agent:To:From:Subject:From; b=gnwfxr27sexq6V278QFbpPYAwxL/H0TCg6ZwlC2CgppFXqsFc2Boz46HcG9klQReD x/S0WFTd1z/OaqNJePMJ0kbCqm6Ht+6au75MTidzbXdZ17b3EJ2XVHl+f/S8kpUs2H 82wW6wm+pebTsPoLBvdRJ9m+Rl1fl7XtGlUwWjgRQem+8xETCRnK37i0/RYDTBTtUB EzROIU/6p5yQoHjO2cD0XTWIGZFy6oaHc2wDqLaCF5n0D3ot/Sreu0golM1zUxcPTK qyiXu17N0UJs7UpQ/MexJHIf5EfqSY5nioH/t7DRQ8/+PQ5i6oyYGqtwU801LXD6lN 7T0onnTzdCw3Q== Message-ID: <3ebe6062-064e-4242-9dc4-5cce5c8ccb41@postgrespro.ru> Date: Sat, 3 Feb 2024 21:21:33 +0300 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Content-Language: en-US To: pgsql-www@postgresql.org From: "Anton A. Melnikov" Subject: Wiki editor request Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi! I would like editor access to the wiki, my username is Antonmel and i would like to modify https://wiki.postgresql.org/wiki/CTEReadme. Seems there should be: SELECT d.* FROM department AS d JOIN WT AS sd ON d.parent_department = sd.id instead of: SELECT d.* FROM WT AS d JOIN subdepartment AS sd ON d.parent_department = sd.id With the best regards, -- Anton A. Melnikov Postgres Professional: http://www.postgrespro.com The Russian Postgres Company