Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Better way to write aggregates?
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: Jan Dittmer <jdi(at)l4x(dot)org>
- Cc: jim(at)contactbda(dot)com, pgsql-performance(at)postgresql(dot)org
- Subject: Re: Better way to write aggregates?
- Date: Fri, 21 Apr 2006 10:26:16 -0400
Jan Dittmer <jdi(at)l4x(dot)org> writes:
> It would help if booleans could be casted to integer 1/0 :-)
As of 8.1 there is such a cast in the system:
regression=# select 't'::bool::int;
int4
------
1
(1 row)
In earlier releases you can make your own.
As for the original question, though: have you looked at the crosstab
functions in contrib/tablefunc?
regards, tom lane
- References:
- Better way to write aggregates?
- From: Jan Dittmer
- Re: Better way to write aggregates?
- From: Jim Buttafuoco
- Re: Better way to write aggregates?
- From: Jan Dittmer
- Better way to write aggregates?
- Prev by Date: Re: Little use of CPU ( < 5%)
- Next by Date: Re: Hardware: HP StorageWorks MSA 1500
- Previous by thread: Re: Better way to write aggregates?
- Next by thread: Little use of CPU ( < 5%)
- Indexes: