http://search.osakos.com/rss.php http://search.osakos.com/rss.php en-us Tue, 12 Aug 2025 22:02:01 GMT Tue, 12 Aug 2025 22:02:01 GMT http://search.osakos.com/cache.php?key=e6ad533722d57428f44247452f7519f7&uri=https%3A%2F%2Fwww.postgresql.org%2Fdocs%2Fcurrent%2Fqueries-with.html%23QUERIES-WITH-RECURSIVE http://search.osakos.com/cache.php?key=e6ad533722d57428f44247452f7519f7 SELECT sub_part, part, quantity FROM parts WHERE part = 'our_product'
UNION ALL
SELECT p.sub_part, p.part, p.quantity * pr.quantity
FROM included_parts pr, parts p
WHERE p.part = pr.sub_part
)
SELECT sub_part, SUM(quantity) as total_quantity
FROM included_parts
GROUP BY sub_part]]> Mon, 04 Aug 2025 01:53:55 GMT http://search.osakos.com/cache.php?key=5a43c2350ed0cdaf50f28ad96a6fc889&uri=https%3A%2F%2Fstackoverflow.com%2Fquestions%2F75740141%2Fpostgres-adding-big-serial-to-an-existing-table http://search.osakos.com/cache.php?key=5a43c2350ed0cdaf50f28ad96a6fc889 Thu, 17 Jul 2025 04:50:38 GMT http://search.osakos.com/cache.php?key=b799b06a89dfd039770471e59e99c834&uri=https%3A%2F%2Fdba.stackexchange.com%2Fquestions%2F65964%2Fhow-do-i-decompose-ctid-into-page-and-row-numbers http://search.osakos.com/cache.php?key=b799b06a89dfd039770471e59e99c834 select ctid, (ctid::text::point)[0]::bigint as ctid1, (ctid::text::point)[1]::bigint as ctid2 from tmp_orphaned_metadata_checklist limit 10;
ctid | ctid1 | ctid2
--------+-------+-------
(0,1) | 0 | 1
(0,2) | 0 | 2
(0,3) | 0 | 3
(0,4) | 0 | 4
(0,5) | 0 | 5
(0,6) | 0 | 6
(0,7) | 0 | 7
(0,8) | 0 | 8
(0,9) | 0 | 9
(0,10) | 0 | 10
(10 rows)


(ctid::text::point)[0]::bigint * 100000000 + (ctid::text::point)[1]::bigint as id]]> Thu, 17 Jul 2025 04:45:13 GMT http://search.osakos.com/cache.php?key=5fadd8c741a9675546123f201cf03330&uri=https%3A%2F%2Fswapnasagarpradhan.medium.com%2Fgetting-started-with-apples-container-cli-on-macos-a-native-alternative-to-docker-fc303e08f5cd http://search.osakos.com/cache.php?key=5fadd8c741a9675546123f201cf03330 Wed, 16 Jul 2025 23:22:27 GMT