Re: [GENERAL] Because PostgreSQL is compiling in old versions of OS?

2017-11-14 Thread Jose Maria Terry Jimenez
El 11/11/17 a las 0:48, DrakoRod escribió: Oh!! Jose Maria TJ wrote You're wrong, that are gcc versions, not OS versions. For example in my CentOS 6 Box cat /etc/redhat-release CentOS release 6.9 (Final) gcc -v [...trimmed...] gcc versión 4.4.7 20120313 (Red Hat 4.4.7-18) (GCC) You're righ

[GENERAL] Error in crosstab using date_trunc

2009-12-05 Thread Jose Maria Terry Jimenez
Hello all, I'm trying to do a crosstab from data that row names are times. These times are timestamps and i want to use they truncating to minutes this works for me: select distinct date_trunc('minute',"timestamp") as "timestamp" from historico order by "timestamp"; Getting times "norm