Re: [GENERAL] [OT?] ETL tools

2005-08-24 Thread Jose Gonzalez Gomez
2005/8/24, Robert Treat <[EMAIL PROTECTED]>: > On Wednesday 24 August 2005 03:50, Jose Gonzalez Gomez wrote: > > Googling a bit I have discovered that what I probably need is an ETL > > (extract, transform and load) tool, preferably open sourced and very > > PostgreSQL

[GENERAL] [OT?] ETL tools

2005-08-24 Thread Jose Gonzalez Gomez
Hi there, I have started working on a new place where they have a lot of medical data stored in relational databases they later exploit with statistical software. The situation is a bit chaotic as they're using a lot of local Access databases, some databases hosted in an old version of Microsoft S

Re: [GENERAL] Foreign key to a view (UNION of two or more tables), any alternative?

2005-06-20 Thread Jose Gonzalez Gomez
On 6/19/05, Karl O. Pinc <[EMAIL PROTECTED]> wrote: > > On 06/19/2005 11:16:34 AM, Jose Gonzalez Gomez wrote: > > On 6/17/05, Bruno Wolff III <[EMAIL PROTECTED]> wrote: > > > On Fri, Jun 17, 2005 at 14:35:01 +0200, > > > Jose Gonzalez Gomez <[EMAIL P

Re: [GENERAL] Foreign key to a view (UNION of two or more tables), any alternative?

2005-06-19 Thread Jose Gonzalez Gomez
On 6/17/05, Bruno Wolff III <[EMAIL PROTECTED]> wrote: > On Fri, Jun 17, 2005 at 14:35:01 +0200, > Jose Gonzalez Gomez <[EMAIL PROTECTED]> wrote: > > > > The problem comes when you have questions that may be not applicable > > (8), or optional (doesn&#

[GENERAL] Foreign key to a view (UNION of two or more tables), any alternative?

2005-06-17 Thread Jose Gonzalez Gomez
Hi there, I have the following problem: I'm developing some forms for data entry for some clinical studies, with data stored on a PostgreSQL database. The study is based in a questionnaire, with stablished options for almost every question. They want answers to be stored as numeric codes so they c