PostgreSQL 8.0 Documentationonly once in the output table. The possible types of qualified join are: INNER JOIN For each row R1 of T1, the joined table has a row for each row in T2 that satisfies the join condition with R1. LEFT libpq - C Library * * CREATE TABLE TBL1 (i int4); * * CREATE TABLE TBL2 (i int4); * * CREATE RULE r1 AS ON INSERT TO TBL1 DO * (INSERT INTO TBL2 VALUES (new.i); NOTIFY TBL2); * * and do this four times:0 码力 | 1422 页 | 9.92 MB | 1 年前3- PostgreSQL 8.0 Documentationonly once in the output table. The possible types of qualified join are: INNER JOIN For each row R1 of T1, the joined table has a row for each row in T2 that satisfies the join condition with R1. LEFT src/test/examples/testlibpq2.sql): * * CREATE TABLE TBL1 (i int4); * * CREATE TABLE TBL2 (i int4); * * CREATE RULE r1 AS ON INSERT TO TBL1 DO * (INSERT INTO TBL2 VALUES (new.i); NOTIFY TBL2); * * and do this four times:0 码力 | 1332 页 | 9.76 MB | 1 年前3
- PostgreSQL 8.1.11 Documentationonly once in the output table. The possible types of qualified join are: INNER JOIN For each row R1 of T1, the joined table has a row for each row in T2 that satisfies the join condition with R1. LEFT src/test/examples/testlibpq2.sql): * * CREATE TABLE TBL1 (i int4); * * CREATE TABLE TBL2 (i int4); * * CREATE RULE r1 AS ON INSERT TO TBL1 DO * (INSERT INTO TBL2 VALUES (new.i); NOTIFY TBL2); * * and do this four times:0 码力 | 1582 页 | 12.19 MB | 1 年前3
- PostgreSQL 8.1 Documentationonly once in the output table. The possible types of qualified join are: INNER JOIN For each row R1 of T1, the joined table has a row for each row in T2 that satisfies the join condition with R1. LEFT src/test/examples/testlibpq2.sql): * * CREATE TABLE TBL1 (i int4); * * CREATE TABLE TBL2 (i int4); * * CREATE RULE r1 AS ON INSERT TO TBL1 DO * (INSERT INTO TBL2 VALUES (new.i); NOTIFY TBL2); * * and do this four times:0 码力 | 1548 页 | 11.54 MB | 1 年前3
- PostgreSQL 8.2 Documentationonly once in the output table. The possible types of qualified join are: INNER JOIN For each row R1 of T1, the joined table has a row for each row in T2 that satisfies the join condition with R1. LEFT src/test/examples/testlibpq2.sql): * * CREATE TABLE TBL1 (i int4); * * CREATE TABLE TBL2 (i int4); * * CREATE RULE r1 AS ON INSERT TO TBL1 DO * (INSERT INTO TBL2 VALUES (new.i); NOTIFY TBL2); 463 Chapter 29. libpq -0 码力 | 1762 页 | 5.43 MB | 1 年前3
- PostgreSQL 8.2 Documentationonly once in the output table. The possible types of qualified join are: INNER JOIN For each row R1 of T1, the joined table has a row for each row in T2 that satisfies the join condition with R1. LEFT src/test/examples/testlibpq2.sql): * * CREATE TABLE TBL1 (i int4); * * CREATE TABLE TBL2 (i int4); * * CREATE RULE r1 AS ON INSERT TO TBL1 DO * (INSERT INTO TBL2 VALUES (new.i); NOTIFY TBL2); 463 Chapter 29. libpq -0 码力 | 1748 页 | 13.12 MB | 1 年前3
- PostgreSQL 9.4 Documentationas explained in detail below. The possible types of qualified join are: INNER JOIN For each row R1 of T1, the joined table has a row for each row in T2 that satisfies the join condition with R1. LEFT search_path = TESTLIBPQ2; * CREATE TABLE TBL1 (i int4); * CREATE TABLE TBL2 (i int4); * CREATE RULE r1 AS ON INSERT TO TBL1 DO * (INSERT INTO TBL2 VALUES (new.i); NOTIFY TBL2); * * Start this program, then host variable named command: sprintf(command, "INSERT INTO test (name, amount, letter) VALUES (’db: ”r1”’, 1, ’f’)"); EXEC SQL EXECUTE IMMEDIATE :command; Compatibility EXECUTE IMMEDIATE is specified in0 码力 | 2603 页 | 6.05 MB | 1 年前3
- PostgreSQL 9.4.26 Documentation
as explained in detail below. The possible types of qualified join are: INNER JOIN For each row R1 of T1, the joined table has a row for each row in T2 that satisfies the join condition with R1. LEFT search_path = TESTLIBPQ2; * CREATE TABLE TBL1 (i int4); * CREATE TABLE TBL2 (i int4); * CREATE RULE r1 AS ON INSERT TO TBL1 DO * (INSERT INTO TBL2 VALUES (new.i); NOTIFY TBL2); * * Start this program, then vari- able named command: sprintf(command, "INSERT INTO test (name, amount, letter) VALUES (’db: ”r1”’, 1, ’f’)"); EXEC SQL EXECUTE IMMEDIATE :command; Compatibility EXECUTE IMMEDIATE is specified in0 码力 | 2452 页 | 5.99 MB | 1 年前3
- PostgreSQL 9.5.25 Documentation
as explained in detail below. The possible types of qualified join are: INNER JOIN For each row R1 of T1, the joined table has a row for each row in T2 that satisfies the join condition with R1. LEFT search_path = TESTLIBPQ2; * CREATE TABLE TBL1 (i int4); * CREATE TABLE TBL2 (i int4); * CREATE RULE r1 AS ON INSERT TO TBL1 DO * (INSERT INTO TBL2 VALUES (new.i); NOTIFY TBL2); * * Start this program, then vari- able named command: sprintf(command, "INSERT INTO test (name, amount, letter) VALUES (’db: ”r1”’, 1, ’f’)"); EXEC SQL EXECUTE IMMEDIATE :command; Compatibility EXECUTE IMMEDIATE is specified in0 码力 | 2558 页 | 6.27 MB | 1 年前3
- PostgreSQL 9.5 Documentationas explained in detail below. The possible types of qualified join are: INNER JOIN For each row R1 of T1, the joined table has a row for each row in T2 that satisfies the join condition with R1. LEFT search_path = TESTLIBPQ2; * CREATE TABLE TBL1 (i int4); * CREATE TABLE TBL2 (i int4); * CREATE RULE r1 AS ON INSERT TO TBL1 DO * (INSERT INTO TBL2 VALUES (new.i); NOTIFY TBL2); * * Start this program, then host variable named command: sprintf(command, "INSERT INTO test (name, amount, letter) VALUES (’db: ”r1”’, 1, ’f’)"); EXEC SQL EXECUTE IMMEDIATE :command; Compatibility EXECUTE IMMEDIATE is specified in0 码力 | 2714 页 | 6.33 MB | 1 年前3
共 40 条
- 1
- 2
- 3
- 4