SQL - display different data
От | Wang, Mary Y |
---|---|
Тема | SQL - display different data |
Дата | |
Msg-id | B8CBC41B7756D6498B08DC37D235863702053D83@xch-sw-05.sw.nos.boeing.com обсуждение исходный текст |
Ответы |
Re: SQL - display different data
|
Список | 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
В списке pgsql-general по дате отправления: