Re: Error in crosstab using date_trunc

Scott Marlowe escribió:
> On Sat, Dec 5, 2009 at 12:11 PM, Jose Maria Terry Jimenez
> <jtj@tssystems.net> wrote:
>
>> 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 "normalized" without seconds.
>>
>> If i do a crosstab using that date_trunc function i get errors. If i do:
>>
>> select *
>> from crosstab
>> (
>> 'select date_trunc('minute',"timestamp") as "timestamp",remota,valor from
>> historico order by 1,2'
>> )
>> as
>> (anet timestamp without time zone,
>> re1 numeric,
>> re2 numeric,
>> re3 numeric
>> )
>> ;
>>
>
> Looks like an escaping issue. Try replacing your outer ' with $outer$
> or something like that:
>
> select *
> from crosstab
> (
> $outer$ select date_trunc('minute',"timestamp") as "timestamp",remota,valor from
> historico order by 1,2 $outer$
> )
> as
> (anet timestamp without time zone,
> re1 numeric,
> re2 numeric,
> re3 numeric
> )
> ;
>
> And see if that helps.
>
>

Thank you very much. This worked, also worked with ' instead $outer$ BUT
escaping the ' in minute with two of them  ' 'minute' '.

What does $outer$ or when i must use it?

Best,
Jose Maria


=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Scanned with Copfilter Version 0.84beta3a (ProxSMTP 1.6)
AntiVirus: ClamAV 0.95.2/10115 - Sun Dec  6 09:37:09 2009
by Markus Madlener @ http://www.copfilter.org