Re: [SQL] how un-suscribe from this list

2007-01-08 Thread Richard Broersma Jr
--- Manso Gomez, Ramon [EMAIL PROTECTED] wrote: I would like to unsuscribe from this list. I donĀ“t know how to do it. Thanks If you are able to view the full headers for any email you get from one of the postgresql mailing lists you would see the following line: List-Unsubscribe: [EMAIL

[SQL] Help with Array

2007-01-08 Thread Jeremiah Elliott
I have a java application that moves data from our erp platform (progress) into a Postgres database. One of the fields in progress is a character array. I haven't had any luck getting this field to transfer. What I would like to do is something like:

Re: [SQL] Help with Array

2007-01-08 Thread Aaron Bono
On 1/8/07, Jeremiah Elliott [EMAIL PROTECTED] wrote: I have a java application that moves data from our erp platform (progress) into a Postgres database. One of the fields in progress is a character array. I haven't had any luck getting this field to transfer. What I would like to do is

[SQL] Table relationships

2007-01-08 Thread Curtis Scheer
I'm having trouble determining the best way to implement the following scenario for a customer database. Given the following tables what is the best way to link an address table to both the Master and the Detail tables. Basically there can be many addresses for each customermaster record and

Fwd: [SQL] Table relationships

2007-01-08 Thread Aaron Bono
-- Forwarded message -- From: Aaron Bono [EMAIL PROTECTED] Date: Jan 8, 2007 4:42 PM Subject: Re: [SQL] Table relationships To: Curtis Scheer [EMAIL PROTECTED] On 1/8/07, Curtis Scheer [EMAIL PROTECTED] wrote: I'm having trouble determining the best way to implement the

Re: [SQL] Table relationships

2007-01-08 Thread Curtis Scheer
-I hope you left out the foreign keys for simplicity. Make sure they get into your database. Yes I left out the foreign keys for simplicity - Is there a difference between an address for the customer detail and an address for the customer? Not really an address is an address, it's a