On Sat, 2012-04-21 at 18:01 +0200, F. BROUARD / SQLpro wrote:
> Le 21/04/2012 16:54, Guillaume Lelarge a écrit :
> > On Sat, 2012-04-21 at 16:17 +0200, F. BROUARD / SQLpro wrote:
> >> Hi there,
> >>
> >> "PostgreSQL 9.1.2, compiled by Visual C++ build 1500, 64-bit"
> >> catalog version : PG_9.1_201
On 21.04.2012 12:59, Andres Freund wrote:
On Friday, April 20, 2012 10:39:25 AM Condor wrote:
array_accumulate aggregate is:
CREATE AGGREGATE array_accumulate (
sfunc = array_append,
basetype = anyelement,
stype = anyarray,
initcond = '{}'
);
Btw, if you replace that by ar
On Sat, 2012-04-21 at 16:17 +0200, F. BROUARD / SQLpro wrote:
> Hi there,
>
> "PostgreSQL 9.1.2, compiled by Visual C++ build 1500, 64-bit"
> catalog version : PG_9.1_201105231
>
> --> the table :
>
> CREATE TABLE T_TEST_TAILLE
> (TTT_IDSERIAL NOT NULL PRIMARY KEY,
> TTT_DATAFIX
F. BROUARD / SQLpro wrote:
> Hi there,
>
> "PostgreSQL 9.1.2, compiled by Visual C++ build 1500, 64-bit"
> catalog version : PG_9.1_201105231
>
> --> the table :
>
> CREATE TABLE T_TEST_TAILLE
> (TTT_IDSERIAL NOT NULL PRIMARY KEY,
> TTT_DATAFIX CHAR(16),
> TTT_DATAVAR V
Hi there,
"PostgreSQL 9.1.2, compiled by Visual C++ build 1500, 64-bit"
catalog version : PG_9.1_201105231
--> the table :
CREATE TABLE T_TEST_TAILLE
(TTT_IDSERIAL NOT NULL PRIMARY KEY,
TTT_DATAFIX CHAR(16),
TTT_DATAVAR VARCHAR(16),
TTT_DATAVARBIGVARCHAR(6000));
On Friday, April 20, 2012 10:39:25 AM Condor wrote:
> array_accumulate aggregate is:
>
>
> CREATE AGGREGATE array_accumulate (
> sfunc = array_append,
> basetype = anyelement,
> stype = anyarray,
> initcond = '{}'
> );
Btw, if you replace that by array_agg which is builtin in
I tried installing 9.1 from the yum repo on a brand new minimal CentOS
6.1 x86_64 install and got an error.
http://pgsql.privatepaste.com/04289a269b
[root@svfis-sg2 ~]# rpm -Uvh pgdg-centos91-9.1-4.noarch.rpm warning:
pgdg-centos91-9.1-4.noarch.rpm: Header V4 DSA/SHA1 Signature, key ID
442df0