SQL - display different data

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

Responses

Browse pgsql-general by date

  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