From: David Goodwin <dof@codepoets.co.uk>
To: pgsql-sql@postgresql.org
Subject: ordering problems ...
Date: Tue, 15 Apr 2003 11:33:29 +0100
Message-ID: <20030415103328.GA3076@codepoets.co.uk> (raw)
Hello everyone,
I have two tables :
question_response and question_response_answer.
There is a one to many relationship between the question_response and a
question_response_answer (schema below at the bottom).
When I execute :
select answer from question_response_answer qra, question_response qr
WHERE qr.response_id = qra.response_id AND qr.personal_id =
'XXYYTEST2' AND qr.module_code = 'TEST990' AND qr.assessment_id = 109
AND qr.question_id = 125 ;
I get :
answer
---------
Foo Bar
Fred
No
Yes
When I execute :
select * from question_response_answer;
I get :
response_id | answer
-------------+------------
148 | Yes
148 | No
148 | Fred
148 | Foo Bar
I'd like to know why the ordering has changed, and is there anything I can do make it the same as it is on the "select * from question_response_answer" "version" ?
Running Postgres 7.3.2 on Linux.
Schema :
Column | Type | Modifiers
---------------+----------------------+--------------------------------------------------------
response_id | integer | not null default
nextval('question_reponse_seq'::text)
question_id | integer |
personal_id | character varying(9) |
assessment_id | integer |
module_code | character varying(9) |
Indexes: question_response_pkey primary key btree (response_id),
question_response_question_id_key unique btree (question_id,
personal_id, assessment_id)
(there are foreign keys, but I've left them off)
tweektest=> \d question_response_answer;
Table "public.question_response_answer"
Column | Type | Modifiers
-------------+---------+-----------
response_id | integer | not null
answer | text | not null
Indexes: question_response_answer_pkey primary key btree (response_id,
answer)
Foreign Key constraints: $1 FOREIGN KEY (response_id) REFERENCES
question_response(response_id) ON UPDATE NO ACTION ON DELETE CASCADE
Thanks in advance,
David.
--
David Goodwin
[ dof at codepoets dot co dot uk ]
[ http://www.codepoets.co.uk ]
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: dof@codepoets.co.uk
Subject: Re: ordering problems ...
In-Reply-To: <20030415103328.GA3076@codepoets.co.uk>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox