PostgreSQL 11.22 Documentationwhich don't correlate with each other and this is when implicit seed parameter comes in handy: \set k1 abs(hash(:r, :default_seed + 123)) % 1000000 \set k2 abs(hash(:r, :default_seed + 321)) % 1000000 new value: UPDATE tab SET h = h || hstore('c', '3'); Delete a key: UPDATE tab SET h = delete(h, 'k1'); Convert a record to an hstore: CREATE TABLE test (col1 integer, col2 text, col3 text); INSERT0 码力 | 2732 页 | 12.44 MB | 1 年前3- PostgreSQL 14.10 Documentationdon't correlate with each other and this is when the optional seed parameter comes in handy: \set k1 1 + permute(:r, :size, :default_seed + 123) \set k2 1 + permute(:r, :size, :default_seed + 321) A h = h || hstore(array['q', 'w'], array['11', '12']); Delete a key: UPDATE tab SET h = delete(h, 'k1'); Convert a record to an hstore: CREATE TABLE test (col1 integer, col2 text, col3 text); INSERT0 码力 | 3032 页 | 13.27 MB | 1 年前3
- PostgreSQL 14.10 Documentationdon't correlate with each other and this is when the optional seed parameter comes in handy: \set k1 1 + permute(:r, :size, :default_seed + 123) \set k2 1 + permute(:r, :size, :default_seed + 321) A h = h || hstore(array['q', 'w'], array['11', '12']); Delete a key: UPDATE tab SET h = delete(h, 'k1'); Convert a record to an hstore: CREATE TABLE test (col1 integer, col2 text, col3 text); INSERT0 码力 | 2871 页 | 13.38 MB | 1 年前3
- PostgreSQL 13.13 Documentationwhich don't correlate with each other and this is when implicit seed parameter comes in handy: \set k1 abs(hash(:r, :default_seed + 123)) % 1000000 \set k2 abs(hash(:r, :default_seed + 321)) % 1000000 new value: UPDATE tab SET h = h || hstore('c', '3'); Delete a key: UPDATE tab SET h = delete(h, 'k1'); Convert a record to an hstore: CREATE TABLE test (col1 integer, col2 text, col3 text); INSERT0 码力 | 2782 页 | 13.00 MB | 1 年前3
- PostgreSQL 12.17 Documentationwhich don't correlate with each other and this is when implicit seed parameter comes in handy: \set k1 abs(hash(:r, :default_seed + 123)) % 1000000 \set k2 abs(hash(:r, :default_seed + 321)) % 1000000 new value: UPDATE tab SET h = h || hstore('c', '3'); Delete a key: UPDATE tab SET h = delete(h, 'k1'); Convert a record to an hstore: CREATE TABLE test (col1 integer, col2 text, col3 text); INSERT0 码力 | 2786 页 | 12.72 MB | 1 年前3
- PostgreSQL 11.22 Documentationcorrelate with each other and this is when implicit seed parameter comes in handy: 1980 pgbench \set k1 abs(hash(:r, :default_seed + 123)) % 1000000 \set k2 abs(hash(:r, :default_seed + 321)) % 1000000 new value: UPDATE tab SET h = h || hstore('c', '3'); Delete a key: UPDATE tab SET h = delete(h, 'k1'); 2679 Additional Supplied Modules Convert a record to an hstore: CREATE TABLE test (col1 integer0 码力 | 2883 页 | 12.34 MB | 1 年前3
- PostgreSQL 12.17 Documentationwhich don't correlate with each other and this is when implicit seed parameter comes in handy: \set k1 abs(hash(:r, :default_seed + 123)) % 1000000 \set k2 abs(hash(:r, :default_seed + 321)) % 1000000 new value: UPDATE tab SET h = h || hstore('c', '3'); Delete a key: UPDATE tab SET h = delete(h, 'k1'); 2737 Additional Supplied Modules Convert a record to an hstore: CREATE TABLE test (col1 integer0 码力 | 2943 页 | 12.61 MB | 1 年前3
- PostgreSQL 13.14 Documentationwhich don't correlate with each other and this is when implicit seed parameter comes in handy: \set k1 abs(hash(:r, :default_seed + 123)) % 1000000 \set k2 abs(hash(:r, :default_seed + 321)) % 1000000 new value: UPDATE tab SET h = h || hstore('c', '3'); Delete a key: UPDATE tab SET h = delete(h, 'k1'); Convert a record to an hstore: CREATE TABLE test (col1 integer, col2 text, col3 text); INSERT0 码力 | 2940 页 | 12.89 MB | 1 年前3
- PostgreSQL 16.1 Documentationdon't correlate with each other and this is when the optional seed parameter comes in handy: \set k1 1 + permute(:r, :size, :default_seed + 123) \set k2 1 + permute(:r, :size, :default_seed + 321) A h = h || hstore(array['q', 'w'], array['11', '12']); Delete a key: UPDATE tab SET h = delete(h, 'k1'); Convert a record to an hstore: CREATE TABLE test (col1 integer, col2 text, col3 text); INSERT0 码力 | 3133 页 | 14.10 MB | 1 年前3
- PostgreSQL 16.1 Documentationdon't correlate with each other and this is when the optional seed parameter comes in handy: \set k1 1 + permute(:r, :size, :default_seed + 123) \set k2 1 + permute(:r, :size, :default_seed + 321) A h = h || hstore(array['q', 'w'], array['11', '12']); Delete a key: UPDATE tab SET h = delete(h, 'k1'); Convert a record to an hstore: CREATE TABLE test (col1 integer, col2 text, col3 text); INSERT0 码力 | 2974 页 | 14.22 MB | 1 年前3
共 34 条
- 1
- 2
- 3
- 4