Be gentle as I come from an Oracle background a long time ago.
I am trying to join several tables with a couple of tables having a one
to many relationship. I got one query working pretty well but the issue
comes about when I add one more table with a one-to-one relationship. I
get a semi/pseudo
Jaime Casanova wrote:
http://www.postgresql.org/docs/7.4/static/queries-table-expressions.html#QUERIES-JOIN
Been there, done that. Bought several tee-shirts.
What do you mean with *complex joins*?
SELECT first, last, username || '@' || dom.domain as emailaddress
FROM cust_main cm
LEFT OUT
First off it has been a while since I needed to go to the
www.postgresql.org documentation ( and site in general ) and the new
layout/design is nice.
Now the question.
I'm reading up on schema and trying to remember from when I last
researched them what the process is to make the
SET s
Or at least it seems that way.
I have Pg 8.0.1 from the PGDG RPMs installed in a Linux-Vserver ( which
I have used before with Pg 7.2 and 7.3 ). I have changed the
postgresql.conf file and added/modified the listen_addresses to the
Vserver's IP. In pgstartup.log I always see these lines after
David B wrote:
Folks,
I'm thinking of replication tools for high volume site.
Postgres on dual Opteron box. 1/2 GB of data.
Did you really mean 1/2 GB? Seems like a mighty small database.
Maybe 1/2 TB or if you were really wild and crazy 1/2 PB.
Sorry but I couldn't resist. I've funny fingered to
