Thread: Fw: joins

Regards
TaChung Huang (黃大忠)

-----Original Message-----
From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Jodi Kanter
Sent: Monday, November 04, 2002 11:38 AM
To: Postgres Admin List
Subject: [ADMIN] joins

Can anyone tell me if there is any real difference between the two different ways to create tables joins?

 

select field1, field2 from table1 join table2 using (field3)

 

vs.

 

select field1, field2 from table1, table 2 where table1.field3=table2.field3

 

Thanks

Jodi

 

 

_______________________________
Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
(434) 924-2846
jkanter@virginia.edu

 

 

 

There's no technical reason why you can't do development this way, just
make sure that each development site has access to the database (via
pg_hba.conf) and perhaps the server as well (to view log output and
such)

Robert Treat

> ----- Original Message -----
> From: tachung_h <mailto:tachung_h@yahoo.com>
> To: 'Jodi Kanter' <mailto:jkanter@virginia.edu>
> Sent: Monday, November 04, 2002 2:44 PM
> Subject: RE: [ADMIN] joins
>
> I need to work with a group of volunteer developers over the Internet.
> Developers might be using Window 2000, XP or Linux and produce programs
> in Tomcat/Java. Is it practical to think that developers would develop
> with a PostgreSQL database over the Web? This is a development
> environment, there is no proprietary data in the database.
>