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: | Raw Message | Whole Thread | 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 |