Tricky join question

Hi all

I have a join problem that seems to be too difficult for me to solve:

I have:

table person
    id          integer,
    name        varchar(32)

data:

1,"Jack"
2,"Jill"
3,"Bob"


table course
    id         integer,
    name       varchar(32)

data:

1,"SQL Beginner"
2,"SQL Advanced"



table person_course
    person_id  number,
    course_id  number

data:

(currently empty)


Now, I would like to know for every person the courses they have taken.

In mysql, the following statement:

SELECT c.id, c.name, pc.person_id
FROM  person as p
       left outer join person_course as pc on p.id = pc.person_id
       right outer join course as c on pc.course_id = c.id
where p.id = 2 order by 1;


will get me the following result:

+---+-----------------------------------------+----------+
| id| name                                    | person_id|
+---+-----------------------------------------+----------+
| 1 | SQL Beginner                            |          |
| 2 | SQL Advanced                            |          |
+---+-----------------------------------------+----------+


Can I get Postgres to give me the same result somehow? The above
statement will return nothing at all under postgres.


Bye
Tim