- PostgreSQL Server Programming(Second Edition)
- Usama Dar Hannu Krosing Jim Mlodgenski Kirk Roybal
- 186字
- 2021-07-23 20:36:50
Acting on the function's results
The previous example showed one way to retrieve, and further process, function results. The following are a few more useful ways to call a function:
SELECT fib(25); SELECT (flatten_application_settings('9.08.97')).*; SELECT * FROM flatten_application_settings('9.08.97');
Any of the preceding methods will create a legal field list in PostgreSQL, which, in turn, can be used in any way the fields in a simple SELECT
statement on a table are used.
The example in the previous section used the results of the flatten_application_settings()
function, a source of data for an INSERT
statement. The following is an example of how to use the same function as a data source for UPDATE
:
UPDATE application_settings_new SET full_name = flat.full_name, description = flat.description, print_certificate = flat.print_certificate, show_advertisements = flat.show_advertisements, show_splash_screen = flat.show_splash_screen FROM flatten_application_settings('9.08.97') flat;
Using the application version as a key, we can update the records in the new table. Isn't this a really handy way to keep up with the changes to the application settings, while both the old and new applications are still active? I'll take any compliments in the form of cash (or beer), please.
- Visual Basic程序開發(學習筆記)
- Software Testing using Visual Studio 2012
- ASP.NET Core Essentials
- MATLAB定量決策五大類問題
- Linux Device Drivers Development
- Mastering Android Development with Kotlin
- The DevOps 2.5 Toolkit
- 基于SpringBoot實現:Java分布式中間件開發入門與實戰
- Getting Started with Polymer
- Mastering Concurrency in Python
- Python Programming for Arduino
- Web編程基礎:HTML5、CSS3、JavaScript(第2版)
- Professional JavaScript
- Learning ROS for Robotics Programming
- 樹莓派開發從零開始學:超好玩的智能小硬件制作書