[GENERAL] How should I get started?

2004-01-18 Thread Leif K-Brooks
I've been programming web applications in PHP/MySQL for a few years. It's worked decently, but I've been getting annoyed with the lack of more advanced features lately. After some reading, I've decided to switch to Perl/PostgreSQL. I'll be discarding all database data for other reason anyway, s

[GENERAL] Automatic joins?

2004-01-17 Thread Leif K-Brooks
I tried posting this before, but I don't think it got posted. Sorry if it did. According to the Wikipedia article on PostgreSQL (http://en.wikipedia.org/wiki/PostgreSQL), it has a feature for automatic joins: "SELECT u.* FROM user u, address a WHERE a.city='New York' and a.user_name=u.user_name I

[GENERAL] Automatic joins?

2004-01-17 Thread Leif K-Brooks
According to the Wikipedia article on PostgreSQL (http://en.wikipedia.org/wiki/PostgreSQL), it has a feature for automatic joins: "SELECT u.* FROM user u, address a WHERE a.city='New York' and a.user_name=u.user_name In Postgres the relationship between users and addresses can be explicity de

[GENERAL] How should I get started?

2004-01-17 Thread Leif K-Brooks
I've been programming web applications in PHP/MySQL for a few years. It's worked pretty well, but I've been getting annoyed with the lack of more advanced features lately. After some reading, I've decided to switch to Perl/PostgreSQL. I'll be discarding all database data for other reason anyway