BUG #10972: string_agg function incorrectly concatenating varying delimiter

The following bug has been logged on the website:

Bug reference: 10972
Logged by: Jeff Fischer
Email address: jeff(at)goaldriven(dot)com
PostgreSQL version: 9.3.1
Operating system: CentOS
Description:

Running the query below will show how the delimiter for the current row is
actually the subsequent rows delimiter. The sequence goes like this:

TestBlah 1
ITTest 2
testfail 3

Yet, the concatened output is this:

"testblah 2 ITtest 3 testfail"

You can see that the delimiter for the current row is actually getting the
subsequent rows delimiter. It's as though the string concat moves to the
next row prior to concatenting the delimiter, which is likely the cause of
this bug.

SELECT
string_agg(
Field1,
' ' || RowIndex::text || ' '
ORDER BY RowIndex) as VeryLongConcatenatedResultsFieldName
FROM (
SELECT
'testblah' as Field1,
1 as RowIndex
UNION
SELECT
'ITtest' as Field1,
2 as RowIndex
UNION
SELECT
'testfail' as Field1,
3 as RowIndex
) t;