Error con la funcion crosstab

From: Kernel <jucabapa(at)gmail(dot)com>
To: Ayuda <pgsql-es-ayuda(at)postgresql(dot)org>
Subject: Error con la funcion crosstab
Date: 2012-02-02 11:20:16
Message-ID: 4F2A7170.4090309@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-es-ayuda

Hola cuando ejecuto este query una vez funciona y otra no

ERROR EN EL LOG:
2012-02-02 11:42:49 CET LOG: proceso de servidor (PID 12556) fue
terminado por una señal 11: Segmentation fault

SQL:
SELECT mthreport.row_name[1] as trabajador, mthreport.row_name[2] as
nombre_trabajador, mthreport.row_name[3] as anyo,
jan, feb, mar, apr, may, jun, jul, aug, sep, oct, nov, dec
FROM
crosstab('
SELECT ARRAY[i.trabajador::text, i.nombre_trabajador::text,
to_char(i.anyo,''9999'')] As row_name,
CASE
WHEN i.mes = 1::int THEN ''jan''::text
WHEN i.mes = 2::int THEN ''feb''::text
WHEN i.mes = 3::int THEN ''mar''::text
WHEN i.mes = 4::int THEN ''apr''::text
WHEN i.mes = 5::int THEN ''may''::text
WHEN i.mes = 6::int THEN ''jun''::text
WHEN i.mes = 7::int THEN ''jul''::text
WHEN i.mes = 8::int THEN ''aug''::text
WHEN i.mes = 9::int THEN ''sep''::text
WHEN i.mes = 10::int THEN ''oct''::text
WHEN i.mes = 11::int THEN ''nov''::text
WHEN i.mes = 12::int THEN ''dec''::text
ELSE NULL::text
END AS mes, i.s_fichados
FROM liv_tiempos_muertos_mes i
WHERE i.anyo = 2012
',
'SELECT to_char(date ''2012-01-01'' + (n ||
''month'')::interval, ''mon'') As short_mname FROM generate_series(0,11) n')
As mthreport(row_name text[], jan int, feb int,
mar int, apr int, may int, jun int, jul int, aug int, sep int, oct int,
nov int, dec int)

Responses

Browse pgsql-es-ayuda by date

  From Date Subject
Next Message Martin Li Causi 2012-02-02 11:53:47 Leer una tabla en Oracle desde Postgres
Previous Message Aitor Gil Martin 2012-02-02 09:57:23 RE: Conectar a SQL Server 8.0.2055 desde PostGres 8.4 en Windows