Let's say I have a table :
create table people (
person_id integer not null primary key,
firstnames varchar(50),
lastname varchar(50)
);
and another
create table partners (
first_person integer not null references people(person_id),
second_person integer not null reference people(person_id)
);
There is an artifical way to do the outer join in PostgreSQL... It
involves using UNION and NOT IN... see :
http://www.postgresql.org/docs/aw_pgsql_book/node305.html
Hope this helps...
-jag
--
"She who is wanting me,
Whose touch can make me cry,
I can only understand
By never asking her why.
What I do is just invoke upper(text(field))... that converts the varchar
to text, which the upper function can then use.
-jag
--
There's so much beauty in the world. Sometimes I feel like
I'm seeing it all at once, and it's too much; my heart
fills up like a balloon that's about to burst. And
