Re: [SQL] abstract data types?

[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 types have not earned a warm place in my
heart ...

-Josh Berkus

[SQL] Question about 'copy' and datetime

[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 postfix. Is this a
bug or there are other options I need to set?

fyi, the command used in the backup script

pg_dump -c -u -f $BACKUP_FILE $DATABASE

and the command used in the restore script

psql -e -u -f $BACKUP_FILE  $DATABASE

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

[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 uses EST. The data dumped also has EST postfix. Is this a
> bug or there are other options I need to set?

Given your return address, I'm betting this is a conflict between USA
and Aussie interpretations of "EST".  You probably need to recompile
with USE_AUSTRALIAN_RULES #defined.  See
http://www.postgresql.org/users-lounge/docs/7.0/postgres/datetime-appendix.htm

regards, tom lane

[SQL] Joining several tables

[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
--
Stephan Richter
CBU - Physics and Chemistry Student
Web2k - Web Design/Development & Technical Project Management