| From: | "Kevin Crenshaw" <kcrenshaw(at)viscient(dot)com> |
|---|---|
| To: | <pgsql-novice(at)postgresql(dot)org> |
| Subject: | SQL Question |
| Date: | 2006-02-22 14:43:09 |
| Message-ID: | 20060222144307.85D3A9DC877@postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
I have a table called 'tasks' with a structure like this:
Taskid ParentId
----------------------------
1 null
2 1
3 1
4 Null
5 4
6 4
7 Null
8 Null
9 15
10 18
The taskid column is the primary key and the parentid column references
values in the taskid column. However, it is possible for the parentid to be
a value that is not found in the taskid column (hence my question.). I need
to write a query that will retrieve all rows where the parentid is either
'null' or does not exist in the taskid column.
Any help would really be appreciated.
Thanks!
Kevin
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Charley Tiggs | 2006-02-22 14:56:27 | Re: drop index |
| Previous Message | Jaromír Kamler | 2006-02-22 13:56:54 | drop index |