PostgreSQL 17beta1 A4 Documentation.......................... 2931 N. Color Support .............................................................................................. 2945 N.1. When Color is Used ........................... 'purple'); CREATE TABLE my_colors (color rainbow, note text); CREATE FUNCTION get_color_note (rainbow) RETURNS text AS 'SELECT note FROM my_colors WHERE color = $1' LANGUAGE SQL; (See Section 36 36.5 for an explanation of SQL-language functions.) PostgreSQL will be aware that the get_color_note function depends on the rainbow type: dropping the type would force dropping the function, because its0 码力 | 3017 页 | 14.45 MB | 1 年前3- PostgreSQL 17beta1 US Documentation........................ 3097 N. Color Support ................................................................................................... 3112 N.1. When Color is Used ........................ 'purple'); CREATE TABLE my_colors (color rainbow, note text); CREATE FUNCTION get_color_note (rainbow) RETURNS text AS 'SELECT note FROM my_colors WHERE color = $1' LANGUAGE SQL; (See Section 36 36.5 for an explanation of SQL-language functions.) PostgreSQL will be aware that the get_color_note function depends on the rainbow type: dropping the type would force dropping the function, because its0 码力 | 3188 页 | 14.32 MB | 1 年前3
- PostgreSQL 16.1 Documentation........................ 3044 N. Color Support ................................................................................................... 3058 N.1. When Color is Used ........................ 'purple'); CREATE TABLE my_colors (color rainbow, note text); CREATE FUNCTION get_color_note (rainbow) RETURNS text AS 'SELECT note FROM my_colors WHERE color = $1' LANGUAGE SQL; (See Section 38 38.5 for an explanation of SQL-language functions.) PostgreSQL will be aware that the get_color_note function depends on the rainbow type: dropping the type would force dropping the function, because its0 码力 | 3133 页 | 14.10 MB | 1 年前3
- PostgreSQL 16.1 Documentation.......................... 2889 N. Color Support .............................................................................................. 2903 N.1. When Color is Used ........................... 'purple'); CREATE TABLE my_colors (color rainbow, note text); CREATE FUNCTION get_color_note (rainbow) RETURNS text AS 'SELECT note FROM my_colors WHERE color = $1' LANGUAGE SQL; (See Section 38 38.5 for an explanation of SQL-language functions.) PostgreSQL will be aware that the get_color_note function depends on the rainbow type: dropping the type would force dropping the function, because its0 码力 | 2974 页 | 14.22 MB | 1 年前3
- PostgreSQL 9.5.25 Documentation
’blue’, ’purple’); CREATE TABLE my_colors (color rainbow, note text); CREATE FUNCTION get_color_note (rainbow) RETURNS text AS ’SELECT note FROM my_colors WHERE color = $1’ LANGUAGE SQL; (See Section 35.4 4 for an explanation of SQL-language functions.) PostgreSQL will be aware that the get_color_note function depends on the rainbow type: dropping the type would force dropping the function, because its would no longer be defined. But PostgreSQL will not consider 87 Chapter 5. Data Definition get_color_note to depend on the my_colors table, and so will not drop the function if the table is dropped.0 码力 | 2558 页 | 6.27 MB | 1 年前3
- PostgreSQL 9.5 Documentation’blue’, ’purple’); CREATE TABLE my_colors (color rainbow, note text); CREATE FUNCTION get_color_note (rainbow) RETURNS text AS ’SELECT note FROM my_colors WHERE color = $1’ LANGUAGE SQL; (See Section 35.4 4 for an explanation of SQL-language functions.) PostgreSQL will be aware that the get_color_note function depends on the rainbow type: dropping the type would force dropping the function, because its its argument type would no longer be defined. But PostgreSQL will not consider get_color_note to depend on the my_colors table, and so will not drop the function if the table is dropped. While there are disadvantages0 码力 | 2714 页 | 6.33 MB | 1 年前3
- PostgreSQL 9.6.24 Documentation’blue’, ’purple’); CREATE TABLE my_colors (color rainbow, note text); CREATE FUNCTION get_color_note (rainbow) RETURNS text AS ’SELECT note FROM my_colors WHERE color = $1’ LANGUAGE SQL; (See Section 36.4 4 for an explanation of SQL-language functions.) PostgreSQL will be aware that the get_color_note function depends on the rainbow type: dropping the type would force dropping the function, because its its argument type would no longer be defined. But PostgreSQL will not consider get_color_note to depend on the my_colors table, and so will not drop the function if the table is dropped. While there are disadvantages0 码力 | 2814 页 | 6.58 MB | 1 年前3
- PostgreSQL 9.6.24 Documentation
’blue’, ’purple’); CREATE TABLE my_colors (color rainbow, note text); CREATE FUNCTION get_color_note (rainbow) RETURNS text AS ’SELECT note FROM my_colors WHERE color = $1’ LANGUAGE SQL; (See Section 36.4 4 for an explanation of SQL-language functions.) PostgreSQL will be aware that the get_color_note function depends on the rainbow type: dropping the type would force dropping the function, because its its argument type would no longer be defined. But PostgreSQL will not consider get_color_note to depend on the my_colors table, and so will not drop the function if the table is dropped. While there are disadvantages0 码力 | 2661 页 | 6.53 MB | 1 年前3
- PostgreSQL 9.4 Documentation’blue’, ’purple’); CREATE TABLE my_colors (color rainbow, note text); CREATE FUNCTION get_color_note (rainbow) RETURNS text AS ’SELECT note FROM my_colors WHERE color = $1’ LANGUAGE SQL; (See Section 35.4 4 for an explanation of SQL-language functions.) PostgreSQL will be aware that the get_color_note function depends on the rainbow type: dropping the type would force dropping the function, because its its argument type would no longer be defined. But PostgreSQL will not consider get_color_note to depend on the my_colors table, and so will not drop the function if the table is dropped. While there are disadvantages0 码力 | 2603 页 | 6.05 MB | 1 年前3
- PostgreSQL 9.4.26 Documentation
’blue’, ’purple’); CREATE TABLE my_colors (color rainbow, note text); CREATE FUNCTION get_color_note (rainbow) RETURNS text AS ’SELECT note FROM my_colors WHERE color = $1’ LANGUAGE SQL; (See Section 35.4 4 for an explanation of SQL-language functions.) PostgreSQL will be aware that the get_color_note function depends on the rainbow type: dropping the type would force dropping the function, because its its argument type would no longer be defined. But PostgreSQL will not consider get_color_note to depend on the my_colors table, and so will not drop the function if the table is dropped. While there are disadvantages0 码力 | 2452 页 | 5.99 MB | 1 年前3
共 40 条
- 1
- 2
- 3
- 4