Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit497913b

Browse files
committed
Version 1.2
- Bug fixes- Add support for array types
1 parentcadb227 commit497913b

File tree

7 files changed

+59
-5
lines changed

7 files changed

+59
-5
lines changed

‎.gitignore‎

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -41,3 +41,4 @@ lib*.pc
4141
/tmp_install/
4242
Dockerfile
4343
pg_variables--1.1.sql
44+
pg_variables--1.2.sql

‎Makefile‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -4,8 +4,8 @@ MODULE_big = pg_variables
44
OBJS = pg_variables.o pg_variables_record.o$(WIN32RES)
55

66
EXTENSION = pg_variables
7-
EXTVERSION = 1.1
8-
DATA = pg_variables--1.0.sql pg_variables--1.0--1.1.sql
7+
EXTVERSION = 1.2
8+
DATA = pg_variables--1.0.sql pg_variables--1.0--1.1.sql pg_variables--1.1--1.2.sql
99
DATA_built =$(EXTENSION)--$(EXTVERSION).sql
1010

1111
PGFILEDESC = "pg_variables - sessional variables"

‎README.md‎

Lines changed: 17 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -91,6 +91,13 @@ Function | Returns
9191
`pgv_set(package text, name text, value anynonarray, is_transactional bool default false)` |`void`
9292
`pgv_get(package text, name text, var_type anynonarray, strict bool default true)` |`anynonarray`
9393

94+
##Array variables functions
95+
96+
Function | Returns
97+
-------- | -------
98+
`pgv_set(package text, name text, value anyarray, is_transactional bool default false)` |`void`
99+
`pgv_get(package text, name text, var_type anyarray, strict bool default true)` |`anyarray`
100+
94101
##**Deprecated** scalar variables functions
95102

96103
###Integer variables
@@ -181,7 +188,7 @@ Note that **pgv_stats()** works only with the PostgreSQL 9.6 and newer.
181188

182189
##Examples
183190

184-
It is easy to use functions to work with scalar variables:
191+
It is easy to use functions to work with scalarand arrayvariables:
185192

186193
```sql
187194
SELECT pgv_set('vars','int1',101);
@@ -196,6 +203,13 @@ SELECT SELECT pgv_get('vars', 'text1', NULL::text);
196203
pgv_get
197204
---------------
198205
text variable
206+
207+
SELECT pgv_set('vars','arr1','{101,102}'::int[]);
208+
209+
SELECT pgv_get('vars','arr1',NULL::int[]);
210+
pgv_get
211+
-----------
212+
{101,102}
199213
```
200214

201215
Let's assume we have a**tab** table:
@@ -246,6 +260,7 @@ You can list packages and variables:
246260
SELECT*FROM pgv_list()order by package, name;
247261
package | name | is_transactional
248262
---------+-------+------------------
263+
vars | arr1 | f
249264
vars | int1 | f
250265
vars | r1 | f
251266
vars | text1 | f
@@ -257,7 +272,7 @@ And get used memory in bytes:
257272
SELECT*FROM pgv_stats()order by package;
258273
package | allocated_memory
259274
---------+------------------
260-
vars |32768
275+
vars |49152
261276
```
262277

263278
You can delete variables or whole packages:

‎pg_variables--1.1--1.2.sql‎

Lines changed: 16 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,16 @@
1+
/* contrib/pg_variables/pg_variables--1.1--1.2.sql*/
2+
3+
-- complain if script is sourced in psql, rather than via ALTER EXTENSION
4+
\echo Use"ALTER EXTENSION pg_variables UPDATE TO '1.2'" to load this file. \quit
5+
6+
-- Functions to work with arrays
7+
8+
CREATEFUNCTIONpgv_set(packagetext, nametext, value anyarray, is_transactional bool default false)
9+
RETURNS void
10+
AS'MODULE_PATHNAME','variable_set_array'
11+
LANGUAGE C VOLATILE;
12+
13+
CREATEFUNCTIONpgv_get(packagetext, nametext, var_type anyarray, strict bool default true)
14+
RETURNS anyarray
15+
AS'MODULE_PATHNAME','variable_get_array'
16+
LANGUAGE C VOLATILE;

‎pg_variables.c‎

Lines changed: 2 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -237,6 +237,7 @@ VARIABLE_GET_TEMPLATE(0, 1, 2, jsonb, JSONBOID)
237237

238238
/* current API */
239239
VARIABLE_GET_TEMPLATE(0,1,3,any,get_fn_expr_argtype(fcinfo->flinfo,2))
240+
VARIABLE_GET_TEMPLATE(0,1,3,array,get_fn_expr_argtype(fcinfo->flinfo,2))
240241

241242

242243
#defineVARIABLE_SET_TEMPLATE(type,typid) \
@@ -275,6 +276,7 @@ VARIABLE_SET_TEMPLATE(jsonb, JSONBOID)
275276

276277
/* current API */
277278
VARIABLE_SET_TEMPLATE(any,get_fn_expr_argtype(fcinfo->flinfo,2))
279+
VARIABLE_SET_TEMPLATE(array,get_fn_expr_argtype(fcinfo->flinfo,2))
278280

279281

280282
Datum

‎pg_variables.control‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
# pg_variables extension
22
comment = 'session variables with various types'
3-
default_version = '1.1'
3+
default_version = '1.2'
44
module_pathname = '$libdir/pg_variables'
55
relocatable = true

‎sql/pg_variables_any.sql‎

Lines changed: 20 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -139,6 +139,26 @@ SELECT pgv_get('vars', 'd1', NULL::jsonb);
139139
SELECT pgv_set('vars','jNULL',NULL::jsonb);
140140
SELECT pgv_get('vars','jNULL',NULL::jsonb);
141141

142+
-- Array variables
143+
SELECT pgv_set('vars','arr1','{1, 2, null}'::int[]);
144+
SELECT pgv_set('vars','arr2','{"bar", "balance", "active"}'::text[]);
145+
SELECT pgv_set('vars2','j1','{1, 2, null}'::int[]);
146+
147+
SELECT pgv_get('vars','arr1',NULL::int[]);
148+
SELECT pgv_get('vars','arr2',NULL::int[]);
149+
SELECT pgv_set('vars','arr1','{"bar", "balance", "active"}'::text[]);
150+
SELECT pgv_set('vars','arr1','{3, 4, 5}'::int[]);
151+
SELECT pgv_get('vars','arr1',NULL::int[]);
152+
153+
SELECT pgv_get('vars','arr3',NULL::int[]);
154+
SELECT pgv_get('vars','arr3',NULL::int[], false);
155+
SELECT pgv_exists('vars','arr3');
156+
SELECT pgv_exists('vars','arr1');
157+
SELECT pgv_get('vars2','j1',NULL::int[]);
158+
159+
SELECT pgv_set('vars','arrNULL',NULL::int[]);
160+
SELECT pgv_get('vars','arrNULL',NULL::int[]);
161+
142162
-- Manipulate variables
143163
SELECT*FROM pgv_list()order by package, name;
144164

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp