From: | lawpoop(at)gmail(dot)com |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | using subselects |
Date: | 2007-06-06 16:19:12 |
Message-ID: | 1181146752.491905.221690@h2g2000hsg.googlegroups.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello everyone -
I'm moving from MySQL to Postgres and I am in a situation where I am
trying to use subselects properly.
I have a table of projects, users, and user_projects. The table
user_projects creates a many-to-many relationship between users and
projects.
I'm creating a select list on a web form for adding a new user to a
project. I want to select users from the user table, who aren't
already listed in the join table under that project.
Here's my select:
SELECT * FROM users
WHERE user_id <> $current_user_id
AND user_id <> ( SELECT user_id FROM user_projects WHERE project_id =
$project_id )
This query returns no rows, even on projects that have no records in
the user_projects table!
I am certain that I am not the $current_user_id. If I run this query:
SELECT * FROM users
WHERE user_id <> $current_user_id
I get all the user records besides myself.
What am I doing wrong?
From | Date | Subject | |
---|---|---|---|
Next Message | Woody Woodring | 2007-06-06 16:21:33 | String trim function - possible bug? |
Previous Message | Erwin Brandstetter | 2007-06-06 15:56:37 | Re: Join field values |