From: | "Wang, Mary Y" <mary(dot)y(dot)wang(at)boeing(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | SQL - display different data |
Date: | 2004-07-21 15:56:51 |
Message-ID: | B8CBC41B7756D6498B08DC37D235863702053D83@xch-sw-05.sw.nos.boeing.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
Here is the table for bug:
Attribute | Type | Modifier
---------------+---------+----------------------------------------------
bug_id | integer | not null default nextval('bug_pk_seq'::text)
group_id | integer | not null default '0'
status_id | integer | not null default '0'
priority | integer | not null default '0'
category_id | integer | not null default '0'
submitted_by | integer | not null default '0'
assigned_to | integer | not null default '0'
date | integer | not null default '0'
summary | text |
details | text |
close_date | integer |
bug_group_id | integer | not null default '0'
resolution_id | integer | not null default '0'
Indices: bug_group_id,
bug_groupid_assignedto_statusid,
bug_groupid_statusid,
bug_pkey
When I get to PostgreSQL , when I typed
"Select bug_id, group_id from bug order by id"
I would all id, and group_id from the bug table.
However, when I type
"Select * from bug where bug_id=166"
No rows are returned.
What puzzled me was able to see the bug_id (166) and group_id for bug_id (166) listed when I did
"Select id, group_id from bug order by id".
Any ideas of what's going on?
Thanks in advance.
Mary
From | Date | Subject | |
---|---|---|---|
Next Message | Markus Wollny | 2004-07-21 16:30:28 | Re: [OpenFTS-general] AW: tsearch2, ispell, utf-8 and german special characters |
Previous Message | Doug McNaught | 2004-07-21 15:31:08 | Re: Insert images through ASP |