separate variable, named the same as the column. For example: => SELECT 'hello' AS var1, 10 AS var2; -> \gset => \echo :var1 :var2 hello 10 If you specify a prefix, that string is prepended to the query's column names to create the variable names to use: => SELECT 'hello' AS var1, 10 AS var2; -> \gset result_ => \echo :result_var1 :result_var2 hello 10 If a column result is NULL, the corresponding variable If the argument is null, the result is null. Example: SELECT xmlcomment('hello'); xmlcomment -------------- Function: xmlconcat Synopsis: xmlconcat(xml[, …]) The function xmlconcat

separate variable, named the same as the column. For example: => SELECT 'hello' AS var1, 10 AS var2; -> \gset => \echo :var1 :var2 hello 10 If you specify a prefix, that string is prepended to the query’s names to create the variable names to use: => SELECT 'hello' AS var1, 10 AS var2; -> \gset result_ => \echo :result_var1 :result_var2 hello 10 If a column result is NULL, the corresponding variable If the argument is null, the result is null. Example: SELECT xmlcomment('hello'); xmlcomment -------------- Function: xmlconcat Synopsis: xmlconcat(xml[, …]) The function xmlconcat

command. VMware Greenplum 6 Documentation VMware, Inc 709 => SELECT 'hello' AS var1, 10 AS var2; -> \gset => \echo :var1 :var2 hello 10 If you specify a prefix, that string is prepended to the query’s column names to create the variable names to use: => SELECT 'hello' AS var1, 10 AS var2; -> \gset result_ => \echo :result_var1 :result_var2 hello 10 If a column result is NULL, the corresponding variable If the argument is null, the result is null. Example: SELECT xmlcomment('hello'); xmlcomment -------------- Function: xmlconcat Synopsis: xmlconcat(xml[, …]) The function xmlconcat

separate variable, named the same as the column. For example: => SELECT 'hello' AS var1, 10 AS var2; -> \gset => \echo :var1 :var2 hello 10 If you specify a prefix, that string is prepended to the query’s column names to create the variable names to use: => SELECT 'hello' AS var1, 10 AS var2; -> \gset result_ => \echo :result_var1 :result_var2 hello 10 If a column result is NULL, the corresponding variable If the argument is null, the result is null. Example: SELECT xmlcomment('hello'); xmlcomment -------------- Function: xmlconcat Synopsis: xmlconcat(xml[, ⋯]) The function xmlconcat

the row is stored into a separate variable, named the same as the column. For example: => SELECT 'hello' AS var1, 10 AS var2; -> \gset => \echo :var1 :var2 Note If you use the \o command to redirect Documentation VMware, Inc. 688 hello 10 If you specify a prefix, that string is prepended to the query's column names to create the variable names to use: => SELECT 'hello' AS var1, 10 AS var2; -> \gset \gset result_ => \echo :result_var1 :result_var2 hello 10 If a column result is NULL, the corresponding variable is unset rather than being set. If the query fails or does not return one row, no variables

separate variable, named the same as the column. For example: => SELECT 'hello' AS var1, 10 AS var2; -> \gset => \echo :var1 :var2 hello 10 If you specify a prefix, that string is prepended to the query’s column names to create the variable names to use: => SELECT 'hello' AS var1, 10 AS var2; -> \gset result_ => \echo :result_var1 :result_var2 hello 10 If a column result is NULL, the corresponding variable If the argument is null, the result is null. Example: SELECT xmlcomment('hello'); xmlcomment -------------- Function: VMware Tanzu Greenplum 6 Documentation VMware, Inc 699 xmlconcat

separate variable, named the same as the column. For example: => SELECT 'hello' AS var1, 10 AS var2; -> \gset => \echo :var1 :var2 hello 10 If you specify a prefix, that string is prepended to the query's names to create the variable names to use: => SELECT 'hello' AS var1, 10 AS var2; -> \gset result_ => \echo :result_var1 :result_var2 hello 10 If a column result is NULL, the corresponding variable If the argument is null, the result is null. Example: SELECT xmlcomment('hello'); xmlcomment -------------- Function: xmlconcat Synopsis: xmlconcat(xml[, …]) The function xmlconcat

plc_python_shared return 'hello from Python' $$ LANGUAGE plcontainer; And test the function using: postgres=# SELECT dummyPython(); dummypython ------------------- hello from Python (1 row) $$ # container: plc_r_shared return ('hello from R') $$ LANGUAGE plcontainer; CREATE FUNCTION postgres=# select dummyR(); dummyr -------------- hello from R (1 row) For further details and how, "who": "Greenplum"} ) $$ LANGUAGE plpythonu; select greet('hello'); greet ------------------- (hello,World) (hello,Greenplum) (2 rows) Running and Preparing SQL Queries The PL/Python

plc_python_shared return 'hello from Python' $$ LANGUAGE plcontainer; And test the function using: postgres=# SELECT dummyPython(); dummypython ------------------- hello from Python (1 row) $$ # container: plc_r_shared return ('hello from R') $$ LANGUAGE plcontainer; CREATE FUNCTION postgres=# select dummyR(); dummyr -------------- hello from R (1 row) For further details and how, "who": "Greenplum"} ) $$ LANGUAGE plpythonu; select greet('hello'); greet ------------------- (hello,World) (hello,Greenplum) (2 rows) Running and Preparing SQL Queries The PL/Python

plc_python_shared return 'hello from Python' $$ LANGUAGE plcontainer; And test the function using: postgres=# SELECT dummyPython(); dummypython ------------------- hello from Python (1 row) # container: plc_r_shared return ('hello from R') $$ LANGUAGE plcontainer; CREATE FUNCTION postgres=# select dummyR(); dummyr -------------- hello from R (1 row) For further details how, "who": "Greenplum"} ) $$ LANGUAGE plpythonu; select greet('hello'); greet ------------------- (hello,World) (hello,Greenplum) (2 rows) Running and Preparing SQL Queries The PL/Python