alter_table.sql

From: Patrick Welche <prlw1(at)newn(dot)cam(dot)ac(dot)uk>
To: pgsql-hackers(at)postgresql(dot)org
Subject: alter_table.sql
Date: 2000-03-07 14:52:27
Message-ID: 20000307145227.H9329@quartz.newn.cam.ac.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

In the alter table regression test, alter_table.sql, it says:

-- 20 values, sorted
SELECT unique1 FROM ten_k WHERE unique1 < 20;

-- 20 values, sorted
SELECT unique2 FROM ten_k WHERE unique2 < 20;

Why sorted? Shouldn't it be

SELECT unique1 FROM ten_k WHERE unique1 < 20 ORDER BY unique1;

if we really expect the output to be sorted?

Cheers,

Patrick

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Meskes 2000-03-07 14:57:45 library policy question
Previous Message Jerome ALET 2000-03-07 10:05:46 Re: [BUGS] grant/revoke bug with delete/update