<programlisting>

schedule.submit_job(query := 'select 1');

</programlisting>

<para>Instead of passing <acronym>SQL</acronym>commandsdirectly, you can define numbered placeholders in the <parameter>query</parameter> argument, such as $1 and $2, and pass an array of<acronym>SQL</acronym> commands in the <parameter>params</parameter> argument, with each array element corresponding to a placeholder. For brevity, you can omit the <parameter>query</parameter> and <parameter>params</parameter> names:</para>

<para>Instead of passing <acronym>SQL</acronym>query parametersdirectly, you can define numbered placeholders in the <parameter>query</parameter> argument, such as $1 and $2, and pass an array ofparameters in the <parameter>params</parameter> argument, with each array element corresponding to a placeholder. For brevity, you can omit the <parameter>query</parameter> and <parameter>params</parameter> names:</para>

<programlisting>

schedule.submit_job(query := 'select $1, $2', params := '{&quot;text 1&quot;, &quot;text 2&quot;}')

</programlisting>

<literal>params</literal>

</entry>

<entry>

<type>text</type>

<type>text[]</type>

</entry>

<entry>

An array of <acronym>SQL</acronym>commands.

An array ofparameters for the<acronym>SQL</acronym>query.

</entry>

</row>

<row>

<literal>params</literal>

</entry>

<entry>

<type>text</type>

<type>text[]</type>

</entry>

<entry>

An array of <acronym>SQL</acronym>commands.

An array ofparameters for the<acronym>SQL</acronym>query.

</entry>

</row>

<row>

</listitem>

<listitem>

<para>

<parameter>params</parameter> &mdash; an array of SQLcommands that can

<parameter>params</parameter> &mdash; an array ofparameters for theSQLquery that can

substitute numbered placeholders in the <parameter>query</parameter> argument, such as $1, $2, etc. Default: <literal>NULL</literal>

</para>

<para>Type: <type>text[]</type></para>