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

Commit94aceed

Browse files
committed
Support multi-dimensional arrays in PL/python.
Multi-dimensional arrays can now be used as arguments to a PL/python function(used to throw an error), and they can be returned as nested Python lists.This makes a backwards-incompatible change to the handling of compositetypes in arrays. Previously, you could return an array of composite typesas "[[col1, col2], [col1, col2]]", but now that is interpreted as a two-dimensional array. Composite types in arrays must now be returned asPython tuples, not lists, to resolve the ambiguity. I.e. "[(col1, col2),(col1, col2)]".To avoid breaking backwards-compatibility, when not necessary, () is stillaccepted for arrays at the top-level, but it is always treated as asingle-dimensional array. Likewise, [] is still accepted for composite types,when they are not in an array. Update the documentation to recommend using []for arrays, and () for composite types, with a mention that those other thingsare also accepted in some contexts.This needs to be mentioned in the release notes.Alexey Grishchenko, Dave Cramer and me. Reviewed by Pavel Stehule.Discussion: <CAH38_tmbqwaUyKs9yagyRra=SMaT45FPBxk1pmTYcM0TyXGG7Q@mail.gmail.com>
1 parent8c035e5 commit94aceed

File tree

7 files changed

+673
-63
lines changed

7 files changed

+673
-63
lines changed

‎doc/src/sgml/plpython.sgml

Lines changed: 37 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -451,13 +451,13 @@ $$ LANGUAGE plpythonu;
451451
<para>
452452
SQL array values are passed into PL/Python as a Python list. To
453453
return an SQL array value out of a PL/Python function, return a
454-
Pythonsequence, for example alist or tuple:
454+
Python list:
455455

456456
<programlisting>
457457
CREATE FUNCTION return_arr()
458458
RETURNS int[]
459459
AS $$
460-
return(1, 2, 3, 4, 5)
460+
return[1, 2, 3, 4, 5]
461461
$$ LANGUAGE plpythonu;
462462

463463
SELECT return_arr();
@@ -467,6 +467,34 @@ SELECT return_arr();
467467
(1 row)
468468
</programlisting>
469469

470+
Multidimensional arrays are passed into PL/Python as nested Python lists.
471+
A 2-dimensional array is a list of lists, for example. When returning
472+
a multi-dimensional SQL array out of a PL/Python function, the inner
473+
lists at each level must all be of the same size. For example:
474+
475+
<programlisting>
476+
CREATE FUNCTION test_type_conversion_array_int4(x int4[]) RETURNS int4[] AS $$
477+
plpy.info(x, type(x))
478+
return x
479+
$$ LANGUAGE plpythonu;
480+
481+
SELECT * FROM test_type_conversion_array_int4(ARRAY[[1,2,3],[4,5,6]]);
482+
INFO: ([[1, 2, 3], [4, 5, 6]], &lt;type 'list'&gt;)
483+
test_type_conversion_array_int4
484+
---------------------------------
485+
{{1,2,3},{4,5,6}}
486+
(1 row)
487+
</programlisting>
488+
489+
Other Python sequences, like tuples, are also accepted for
490+
backwards-compatibility with PostgreSQL versions 9.6 and below, when
491+
multi-dimensional arrays were not supported. However, they are always
492+
treated as one-dimensional arrays, because they are ambiguous with
493+
composite types. For the same reason, when a composite type is used in a
494+
multi-dimensional array, it must be represented by a tuple, rather than a
495+
list.
496+
</para>
497+
<para>
470498
Note that in Python, strings are sequences, which can have
471499
undesirable effects that might be familiar to Python programmers:
472500

@@ -541,14 +569,19 @@ CREATE TYPE named_value AS (
541569
CREATE FUNCTION make_pair (name text, value integer)
542570
RETURNS named_value
543571
AS $$
544-
return[ name, value]
545-
# or alternatively, as tuple: return( name, value)
572+
return( name, value)
573+
# or alternatively, as tuple: return[ name, value]
546574
$$ LANGUAGE plpythonu;
547575
</programlisting>
548576

549577
To return a SQL null for any column, insert <symbol>None</symbol> at
550578
the corresponding position.
551579
</para>
580+
<para>
581+
When an array of composite types is returned, it cannot be returned as a list,
582+
because it is ambiguous whether the Python list represents a composite type,
583+
or another array dimension.
584+
</para>
552585
</listitem>
553586
</varlistentry>
554587

‎src/pl/plpython/expected/plpython_composite.out

Lines changed: 13 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -465,13 +465,13 @@ SELECT * FROM changing_test();
465465

466466
-- tables of composite types
467467
CREATE FUNCTION composite_types_table(OUT tab table_record[], OUT typ type_record[] ) RETURNS SETOF record AS $$
468-
yield {'tab': [['first', 1], ['second', 2]],
468+
yield {'tab': [('first', 1), ('second', 2)],
469469
'typ': [{'first': 'third', 'second': 3},
470470
{'first': 'fourth', 'second': 4}]}
471-
yield {'tab': [['first', 1], ['second', 2]],
471+
yield {'tab': [('first', 1), ('second', 2)],
472472
'typ': [{'first': 'third', 'second': 3},
473473
{'first': 'fourth', 'second': 4}]}
474-
yield {'tab': [['first', 1], ['second', 2]],
474+
yield {'tab': [('first', 1), ('second', 2)],
475475
'typ': [{'first': 'third', 'second': 3},
476476
{'first': 'fourth', 'second': 4}]}
477477
$$ LANGUAGE plpythonu;
@@ -569,3 +569,13 @@ SELECT * FROM return_record_2('v3') AS (v1 int, v2 int, v3 int);
569569
1 | 2 | 3
570570
(1 row)
571571

572+
-- multi-dimensional array of composite types.
573+
CREATE FUNCTION composite_type_as_list() RETURNS type_record[] AS $$
574+
return [[('first', 1), ('second', 1)], [('first', 2), ('second', 2)], [('first', 3), ('second', 3)]];
575+
$$ LANGUAGE plpython3u;
576+
SELECT * FROM composite_type_as_list();
577+
composite_type_as_list
578+
------------------------------------------------------------------------------------
579+
{{"(first,1)","(second,1)"},{"(first,2)","(second,2)"},{"(first,3)","(second,3)"}}
580+
(1 row)
581+

0 commit comments

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