- Archive: 9781849516983_code.zip
- Path: /TS_INT/TS-DOCS/_tmp/~ PostgreSQL/PostgreSQL Server Programming/9781849516983_code.zip
- Date Modified: 2025-07-07 05:03:28
- File size: 128.8 KB
- MIME-type: application/zip
- Files in archive: 104
- Total size: 644.79 KB
- Size in archive: 103.29 KB
- Compression: 16%
6983OS_Code/
6983OS_Code/code/
6983OS_Code/code/chapter01/
6983OS_Code/code/chapter01/sample1.sql (1.13 KB)
6983OS_Code/code/chapter01/sample2.sql (2.51 KB)
6983OS_Code/code/chapter01/sample3.sql (1 KB)
6983OS_Code/code/chapter01/sample4.sql (4.85 KB)
6983OS_Code/code/chapter02/
6983OS_Code/code/chapter02/function_1.php (313 B)
6983OS_Code/code/chapter02/function_2.php (150 B)
6983OS_Code/code/chapter02/function_3_addition_2.plpgsql (178 B)
6983OS_Code/code/chapter02/function_4_addition_3.plpgsql (192 B)
6983OS_Code/code/chapter02/function_5_addition_many.plpgsql (226 B)
6983OS_Code/code/chapter03/
6983OS_Code/code/chapter03/function_1_mid.plpgsql (130 B)
6983OS_Code/code/chapter03/function_2_mid.plpgsql (159 B)
6983OS_Code/code/chapter03/function_3_ambiguous.plpgsql (319 B)
6983OS_Code/code/chapter03/function_4_format_us_full_name.plpgsql (2.49 KB)
6983OS_Code/code/chapter03/function_5_format_us_full_name_WARNING.plpgsql (2.98 KB)
6983OS_Code/code/chapter03/function_6_fif.plpgsql (374 B)
6983OS_Code/code/chapter03/function_7_flatten_application_settings.plpgsql (2.73 KB)
6983OS_Code/code/chapter04/
6983OS_Code/code/chapter04/function_10_run_a_query.plpgsql (221 B)
6983OS_Code/code/chapter04/function_11_array_to_rows.plpgsql (256 B)
6983OS_Code/code/chapter04/function_12_unnest_v.plpgsql (162 B)
6983OS_Code/code/chapter04/function_13_myfunc.plpgsql (226 B)
6983OS_Code/code/chapter04/function_14_myfunc2.plpgsql (190 B)
6983OS_Code/code/chapter04/function_15_curtest1.plpgsql (351 B)
6983OS_Code/code/chapter04/function_16_curtest2.plpgsql (434 B)
6983OS_Code/code/chapter04/function_1_fibonacci_seq.plpgsql (361 B)
6983OS_Code/code/chapter04/function_2_installed_languages.plpgsql (161 B)
6983OS_Code/code/chapter04/function_3_running_queries.plpgsql (310 B)
6983OS_Code/code/chapter04/function_4_running_queries.plpgsql (569 B)
6983OS_Code/code/chapter04/function_5_positives.plpgsql (289 B)
6983OS_Code/code/chapter04/function_6_permutations.plpgsql (395 B)
6983OS_Code/code/chapter04/function_7_permutations2.plpgsql (150 B)
6983OS_Code/code/chapter04/function_8_permutations2.plpgsql (153 B)
6983OS_Code/code/chapter04/function_9_permutations2.plpgsql (196 B)
6983OS_Code/code/chapter04/view_1_running_queries.sql (175 B)
6983OS_Code/code/chapter04/view_2_running_queries.sql (218 B)
6983OS_Code/code/chapter05/
6983OS_Code/code/chapter05/trigger_10_conditional.sql (407 B)
6983OS_Code/code/chapter05/trigger_1_notify.sql (524 B)
6983OS_Code/code/chapter05/trigger_2_notify.sql (282 B)
6983OS_Code/code/chapter05/trigger_3_notify.sql (245 B)
6983OS_Code/code/chapter05/trigger_4_notify.sql (138 B)
6983OS_Code/code/chapter05/trigger_5_notify_truncate.sql (132 B)
6983OS_Code/code/chapter05/trigger_6_audit.sql (1.17 KB)
6983OS_Code/code/chapter05/trigger_7_cancel_op.sql (674 B)
6983OS_Code/code/chapter05/trigger_8_stamp.sql (595 B)
6983OS_Code/code/chapter05/trigger_9_usagestamp.sql (527 B)
6983OS_Code/code/chapter06/
6983OS_Code/code/chapter06/function_1_format.plpgsql (1.28 KB)
6983OS_Code/code/chapter06/function_2_validate.plpgsql (968 B)
6983OS_Code/code/chapter06/function_3_validate_status.plpgsql (460 B)
6983OS_Code/code/chapter07/
6983OS_Code/code/chapter07/function_10_fact.plpython (204 B)
6983OS_Code/code/chapter07/function_11_fact.plpython (230 B)
6983OS_Code/code/chapter07/function_12_stdout.plpython (1008 B)
6983OS_Code/code/chapter07/function_13_thumbnail.plpython (820 B)
6983OS_Code/code/chapter07/function_14_email.plpython (654 B)
6983OS_Code/code/chapter07/function_1_gethostbyname.plpython (164 B)
6983OS_Code/code/chapter07/function_2_hello.plpython (110 B)
6983OS_Code/code/chapter07/function_3_add_one.plpython (90 B)
6983OS_Code/code/chapter07/function_4_userinfo.plpython (1.41 KB)
6983OS_Code/code/chapter07/function_5_even_list.plpython (129 B)
6983OS_Code/code/chapter07/function_6_even_generator.plpython (170 B)
6983OS_Code/code/chapter07/function_7_even_yield.plpython (260 B)
6983OS_Code/code/chapter07/function_8_birthdates.plpython (272 B)
6983OS_Code/code/chapter07/function_9_rollback.plpython (320 B)
6983OS_Code/code/chapter07/logtrigger/
6983OS_Code/code/chapter07/logtrigger/udp_log_listener.py (690 B)
6983OS_Code/code/chapter07/trigger_1_notify.sql (241 B)
6983OS_Code/code/chapter07/trigger_2_expore.sql (881 B)
6983OS_Code/code/chapter07/trigger_3_log.sql (1.75 KB)
6983OS_Code/code/chapter08/
6983OS_Code/code/chapter08/add_c_nulls/
6983OS_Code/code/chapter08/add_c_nulls/add_func.c (480 B)
6983OS_Code/code/chapter08/add_c_nulls/add_func.sql.in (118 B)
6983OS_Code/code/chapter08/add_c_nulls/Makefile (122 B)
6983OS_Code/code/chapter08/add_c_strict/
6983OS_Code/code/chapter08/add_c_strict/add_func.c (666 B)
6983OS_Code/code/chapter08/add_c_strict/add_func.sql.in (344 B)
6983OS_Code/code/chapter08/add_c_strict/add_func_v0.c (403 B)
6983OS_Code/code/chapter08/add_c_strict/Makefile (122 B)
6983OS_Code/code/chapter08/add_c_variadic/
6983OS_Code/code/chapter08/add_c_variadic/add_func.c (1.55 KB)
6983OS_Code/code/chapter08/add_c_variadic/add_func.sql.in (257 B)
6983OS_Code/code/chapter08/add_c_variadic/Makefile (122 B)
6983OS_Code/code/chapter08/c_functions/
6983OS_Code/code/chapter08/c_functions/compile.sh (87 B)
6983OS_Code/code/chapter08/c_functions/inter_backend_lwlocks.c (1003 B)
6983OS_Code/code/chapter08/c_functions/Makefile (174 B)
6983OS_Code/code/chapter08/c_functions/on_commit_actions.c (8.11 KB)
6983OS_Code/code/chapter08/c_functions/on_commit_actions.sql.in (2.33 KB)
6983OS_Code/code/chapter08/c_functions/README.on_commit_actions (0 B)
6983OS_Code/code/chapter08/ip4r-1.05/
6983OS_Code/code/chapter08/ip4r-1.05/ip4r.c (44.84 KB)
6983OS_Code/code/chapter08/ip4r-1.05/ip4r.sql.in (19.08 KB)
6983OS_Code/code/chapter08/ip4r-1.05/Makefile (486 B)
6983OS_Code/code/chapter08/ip4r-1.05/README.ip4r (13.84 KB)
6983OS_Code/code/chapter08/ip4r-1.05/TODO (206 B)
6983OS_Code/code/chapter08/prefix-1.1.0/
6983OS_Code/code/chapter08/prefix-1.1.0/.gitignore (23 B)
6983OS_Code/code/chapter08/prefix-1.1.0/Makefile (1.59 KB)
6983OS_Code/code/chapter08/prefix-1.1.0/prefix.c (48.87 KB)
6983OS_Code/code/chapter08/prefix-1.1.0/prefix.spec (1.32 KB)
6983OS_Code/code/chapter08/prefix-1.1.0/prefix.sql.in (9.38 KB)
6983OS_Code/code/chapter08/prefix-1.1.0/prefixes.fr.csv (428.24 KB)
6983OS_Code/code/chapter08/prefix-1.1.0/prefixes.sql (256 B)
6983OS_Code/code/chapter08/prefix-1.1.0/queries.sql (1.15 KB)
6983OS_Code/code/chapter08/prefix-1.1.0/ranges.sql (1.15 KB)
6983OS_Code/code/chapter08/prefix-1.1.0/README.txt (6.05 KB)
6983OS_Code/code/chapter08/prefix-1.1.0/TESTS.txt (4.45 KB)
6983OS_Code/code/chapter08/spi_samples/
6983OS_Code/code/chapter08/spi_samples/Makefile (146 B)
6983OS_Code/code/chapter08/spi_samples/spi_count_query_rows.c (1.43 KB)
6983OS_Code/code/chapter08/spi_samples/spi_count_query_rows.sql.in (153 B)
6983OS_Code/code/chapter09/
6983OS_Code/code/chapter09/chat_server/
6983OS_Code/code/chapter09/chat_server/functions.sql (2.87 KB)
6983OS_Code/code/chapter09/chat_server/proxy_functions.sql (1.66 KB)
6983OS_Code/code/chapter09/chat_server/tables.sql (621 B)
6983OS_Code/code/Readme.txt.txt (321 B)