Re: [GENERAL] PostgreSQL and Crystal Report

2007-09-05 Thread Rob Kirkbride
On 05/09/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > Hi All. > I've the necessity to use Crystal Report in my C++ project to report (in > PDF) some PostgreSQL table. > Any idea how to implement this functionality in my C++ project, or where I > can find some useful CR documentation? > All

Re: [GENERAL] Data Warehousing

2007-09-03 Thread Rob Kirkbride
Andrej Ricnik-Bay wrote: On 9/3/07, Rob Kirkbride <[EMAIL PROTECTED]> wrote: We're using hibernate to write to the database. Partitioning looks like it will be too much of a re-architecture. In reply to Andrej we do have a logged_time entity in the required tables. That being t

Re: [GENERAL] Data Warehousing

2007-09-03 Thread Rob Kirkbride
On 03/09/07, Scott Marlowe <[EMAIL PROTECTED]> wrote: > > On 9/3/07, Rob Kirkbride <[EMAIL PROTECTED]> wrote: > > Hi, > > > > I've got a postgres database collected logged data. This data I have to > keep > > for at least 3 years. The d

[GENERAL] Data Warehousing

2007-09-03 Thread Rob Kirkbride
Hi, I've got a postgres database collected logged data. This data I have to keep for at least 3 years. The data in the first instance is being recorded in a postgres cluster. This then needs to be moved a reports database server for analysis. Therefore I'd like a job to dump data on the cluster sa

Re: [GENERAL] Optimising Union Query.

2005-04-25 Thread Rob Kirkbride
Jim C. Nasby wrote on 25/04/2005 01:28: On Sat, Apr 23, 2005 at 10:39:14PM +, Patrick TJ McPhee wrote: In article <[EMAIL PROTECTED]>, Rob Kirkbride <[EMAIL PROTECTED]> wrote: % I've done a explain analyze and as I expected the database has to check % every row in each of

[GENERAL] Optimising Union Query.

2005-04-22 Thread Rob Kirkbride
Hi, I've got a query that takes quite some time to complete. I'm not an SQL expert so I'm not sure how to improve things. I've done a explain analyze and as I expected the database has to check every row in each of the three tables below but I'm wondering if I can do it much quicker by a use of

[GENERAL] Time

2005-04-04 Thread Rob Kirkbride
Hi, I'm trying to fetch out the epoch value of a time, the data type is 'timestamp with time zone'. When I do select extract(epoch from time) it returns a fractional part as well. Am I doing this the correct way? Is the fractional part microseconds? Thanks for any help, Rob