PostgreSQL 9.5.25 Documentation
explicitly: INSERT INTO weather (city, temp_lo, temp_hi, prcp, date) VALUES (’San Francisco’, 43, 57, 0.0, ’1994-11-29’); You can list the columns in a different order if you wish or even omit some columns weather of San Francisco on rainy days: SELECT * FROM weather WHERE city = ’San Francisco’ AND prcp > 0.0; Result: city | temp_lo | temp_hi | prcp | date ---------------+---------+---------+------+------------ date date ); Now try inserting an invalid record: INSERT INTO weather VALUES (’Berkeley’, 45, 53, 0.0, ’1994-11-28’); ERROR: insert or update on table "weather" violates foreign key constraint "weather_city_fkey"0 码力 | 2558 页 | 6.27 MB | 1 年前3
PostgreSQL 9.5 Documentationexplicitly: INSERT INTO weather (city, temp_lo, temp_hi, prcp, date) VALUES (’San Francisco’, 43, 57, 0.0, ’1994-11-29’); You can list the columns in a different order if you wish or even omit some columns weather of San Francisco on rainy days: SELECT * FROM weather WHERE city = ’San Francisco’ AND prcp > 0.0; Result: city | temp_lo | temp_hi | prcp | date ---------------+---------+---------+------+------------ date date ); Now try inserting an invalid record: INSERT INTO weather VALUES (’Berkeley’, 45, 53, 0.0, ’1994-11-28’); ERROR: insert or update on table "weather" violates foreign key constraint "weather_city_fkey"0 码力 | 2714 页 | 6.33 MB | 1 年前3
PostgreSQL 9.4 Documentationexplicitly: INSERT INTO weather (city, temp_lo, temp_hi, prcp, date) VALUES (’San Francisco’, 43, 57, 0.0, ’1994-11-29’); You can list the columns in a different order if you wish or even omit some columns weather of San Francisco on rainy days: SELECT * FROM weather WHERE city = ’San Francisco’ AND prcp > 0.0; Result: city | temp_lo | temp_hi | prcp | date ---------------+---------+---------+------+------------ date date ); Now try inserting an invalid record: INSERT INTO weather VALUES (’Berkeley’, 45, 53, 0.0, ’1994-11-28’); ERROR: insert or update on table "weather" violates foreign key constraint "weather_city_fkey"0 码力 | 2603 页 | 6.05 MB | 1 年前3
PostgreSQL 9.4.26 Documentation
explicitly: INSERT INTO weather (city, temp_lo, temp_hi, prcp, date) VALUES (’San Francisco’, 43, 57, 0.0, ’1994-11-29’); You can list the columns in a different order if you wish or even omit some columns weather of San Francisco on rainy days: SELECT * FROM weather WHERE city = ’San Francisco’ AND prcp > 0.0; Result: city | temp_lo | temp_hi | prcp | date ---------------+---------+---------+------+------------ date date ); Now try inserting an invalid record: INSERT INTO weather VALUES (’Berkeley’, 45, 53, 0.0, ’1994-11-28’); ERROR: insert or update on table "weather" violates foreign key constraint "weather_city_fkey"0 码力 | 2452 页 | 5.99 MB | 1 年前3
PostgreSQL 10.23 DocumentationLanguage INSERT INTO weather (city, temp_lo, temp_hi, prcp, date) VALUES ('San Francisco', 43, 57, 0.0, '1994-11-29'); You can list the columns in a different order if you wish or even omit some columns of San Francisco on rainy days: SELECT * FROM weather WHERE city = 'San Francisco' AND prcp > 0.0; Result: city | temp_lo | temp_hi | prcp | date ---------------+---------+--------- date ); Now try inserting an invalid record: INSERT INTO weather VALUES ('Berkeley', 45, 53, 0.0, '1994-11-28'); ERROR: insert or update on table "weather" violates foreign key constraint "weather_city_fkey"0 码力 | 2727 页 | 11.93 MB | 1 年前3
PostgreSQL 10.23 Documentationexplicitly: INSERT INTO weather (city, temp_lo, temp_hi, prcp, date) VALUES ('San Francisco', 43, 57, 0.0, '1994-11-29'); You can list the columns in a different order if you wish or even omit some columns of San Francisco on rainy days: SELECT * FROM weather WHERE city = 'San Francisco' AND prcp > 0.0; Result: city | temp_lo | temp_hi | prcp | date ---------------+---------+--------- date ); Now try inserting an invalid record: INSERT INTO weather VALUES ('Berkeley', 45, 53, 0.0, '1994-11-28'); ERROR: insert or update on table "weather" violates foreign key constraint "weather_city_fkey"0 码力 | 2590 页 | 12.03 MB | 1 年前3
PostgreSQL 9.6.24 Documentationexplicitly: INSERT INTO weather (city, temp_lo, temp_hi, prcp, date) VALUES (’San Francisco’, 43, 57, 0.0, ’1994-11-29’); You can list the columns in a different order if you wish or even omit some columns weather of San Francisco on rainy days: SELECT * FROM weather WHERE city = ’San Francisco’ AND prcp > 0.0; Result: city | temp_lo | temp_hi | prcp | date ---------------+---------+---------+------+------------ date date ); Now try inserting an invalid record: INSERT INTO weather VALUES (’Berkeley’, 45, 53, 0.0, ’1994-11-28’); ERROR: insert or update on table "weather" violates foreign key constraint "weather_city_fkey"0 码力 | 2814 页 | 6.58 MB | 1 年前3
PostgreSQL 9.6.24 Documentation
explicitly: INSERT INTO weather (city, temp_lo, temp_hi, prcp, date) VALUES (’San Francisco’, 43, 57, 0.0, ’1994-11-29’); You can list the columns in a different order if you wish or even omit some columns weather of San Francisco on rainy days: SELECT * FROM weather WHERE city = ’San Francisco’ AND prcp > 0.0; Result: city | temp_lo | temp_hi | prcp | date ---------------+---------+---------+------+------------ date date ); Now try inserting an invalid record: INSERT INTO weather VALUES (’Berkeley’, 45, 53, 0.0, ’1994-11-28’); ERROR: insert or update on table "weather" violates foreign key constraint "weather_city_fkey"0 码力 | 2661 页 | 6.53 MB | 1 年前3
PostgreSQL 11.22 Documentationexplicitly: INSERT INTO weather (city, temp_lo, temp_hi, prcp, date) VALUES ('San Francisco', 43, 57, 0.0, '1994-11-29'); You can list the columns in a different order if you wish or even omit some columns of San Francisco on rainy days: SELECT * FROM weather WHERE city = 'San Francisco' AND prcp > 0.0; Result: city | temp_lo | temp_hi | prcp | date ---------------+---------+--------- date ); Now try inserting an invalid record: INSERT INTO weather VALUES ('Berkeley', 45, 53, 0.0, '1994-11-28'); ERROR: insert or update on table "weather" violates foreign key constraint "weather_city_fkey"0 码力 | 2732 页 | 12.44 MB | 1 年前3
PostgreSQL 14.10 Documentationexplicitly: INSERT INTO weather (city, temp_lo, temp_hi, prcp, date) VALUES ('San Francisco', 43, 57, 0.0, '1994-11-29'); You can list the columns in a different order if you wish or even omit some columns of San Francisco on rainy days: SELECT * FROM weather WHERE city = 'San Francisco' AND prcp > 0.0; Result: city | temp_lo | temp_hi | prcp | date ---------------+---------+--------- date ); Now try inserting an invalid record: INSERT INTO weather VALUES ('Berkeley', 45, 53, 0.0, '1994-11-28'); ERROR: insert or update on table "weather" violates foreign key constraint "weather_city_fkey"0 码力 | 3032 页 | 13.27 MB | 1 年前3
共 40 条
- 1
- 2
- 3
- 4













