[SQL] Joining several tables

2001-01-21 Thread Stephan Richter
Hello, I have the following situation: I have an Address, PhoneNumber and Contact table all having a contactid in common, but sometimes the phone number does not exist. I want to join these three tables. How do I do that? I could not find the syntax for multiple tables... Regards, Stephan --

Re: [SQL] Question about 'copy' and datetime

2001-01-21 Thread Tom Lane
Carolyn Lu Wong <[EMAIL PROTECTED]> writes: > I find that when I try to restore a backup database (done by pg_dump), > the datetime value seem inconsistent. I've checked the dumped file, > the data seems alright. However, the imported date is +16hr of the > date in the data file. > The system use

[SQL] Question about 'copy' and datetime

2001-01-21 Thread Carolyn Lu Wong
I'm using V6.5. I find that when I try to restore a backup database (done by pg_dump), the datetime value seem inconsistent. I've checked the dumped file, the data seems alright. However, the imported date is +16hr of the date in the data file. The system uses EST. The data dumped also has EST p

Re: [SQL] abstract data types?

2001-01-21 Thread Josh Berkus
Jim, > > I'm trying to figure out what support PostgreSQL > offers for SQL99 > > abstract data types. I'm a little curious why what you're attempting couldn't be done with two columns rather than inventing your own data type. As somebody who often rescues databases gone bad, composite data ty