linkend="functions-formatting-table"><function>to_timestamp()</></link>

and <function>to_date()</> format strings to consume a corresponding

number of characters in the input string (whitespace or not), then

conditionallyadditional adjacent whitespace if not in <literal>FX</>

conditionallyconsume adjacent whitespace if not in <literal>FX</>

mode (Jeevan Chalke)

</para>

format string behaved like a single whitespace character and consumed

all adjacent whitespace in the input string. For example, previously

format string space-space-space would consume only the first space in

' 12', while it willnot consume all three characters.

' 12', while it willnow consume all three characters.

</para>

</listitem>

</para>

<para>

Previously empty arrays were returned as one-dimensional empty arrays

Previously, empty arrays were returned as one-dimensional empty arrays

whose text representation looked the same as zero-dimensional arrays

(<literal>{}</>). <application>intarray</>'s behavior in this area

now matches the built-in array operators.

<listitem>

<para>

NULL <link

DisallowNULL <link

linkend="xfunc-sql-variadic-functions"><literal>VARIADIC</></link>

function argumentsare now disallowed(Pavel Stehule)

function arguments (Pavel Stehule)

</para>

<para>

<listitem>

<para>

<command>DISCARD ALL</> now also discardsthe state of sequences.

<command>DISCARD ALL</> now also discardssequence state.

</para>

</listitem>

<listitem>

<para>

During immediate shutdown, send uncatchable termination signals

During immediate shutdown send uncatchable termination signals

to child processes that have not already shutdown (MauMau,

&Aacute;lvaro Herrera)

</para>

<para>

In contrast

to <link linkend="guc-local-preload-libraries"><varname>local_preload_libraries</></link>,

to <link linkend="guc-local-preload-libraries"><varname>local_preload_libraries</></link>

this parameter can load any shared library, not just those in

the <filename>$libdir/plugins</> directory.

</para>

<listitem>

<para>

Have Windows <acronym>ASCII</>-encoded databases and server process

(e.g. <link linkend="app-postmaster">postmaster) emit messages

in the <envar>LC_CTYPE</></link>-defined language (Alexander Law,

(e.g. <link linkend="app-postmaster">postmaster</>) emit messages

in the <envar>LC_CTYPE</>-defined language (Alexander Law,

Noah Misch)

</para>

<listitem>

<para>

Add <link linkend="queries-tablefunctions"><literal>WITH

ORDINALITY</></link> syntaxwhich numbers rows returned from

ORDINALITY</></link> syntaxto number rows returned from

<literal>FROM</>-clause functions (Andrew Gierth, David Fetter)

</para>

Add <command>FORCE NULL</> option

to <link linkend="SQL-COPY"><command>COPY FROM</></link> which causes

quoted strings matching the null string to be converted to NULL in

in<literal>CSV</> mode (Ian Barwick, Michael Paquier)

<literal>CSV</> mode (Ian Barwick, Michael Paquier)

</para>

<para>

<listitem>

<para>

Improvethe internal definition ofsystem relations (Andres Freund,

Improvehowsystem-level relations are designated (Andres Freund,

Robert Haas)

</para>