postgres 7.1.2 a trideni CH

Milan Roubal roubm9am na barbora.ms.mff.cuni.cz
Pátek Listopad 16 12:30:18 CET 2001


test=# select * from trid order by text;
  text
---------
 humac
 chabada
 ikona
(3 rows)

test=# select * from trid order by text desc;
  text
---------
 ikona
 chabada
 humac
(3 rows)

staci?
Zdravi
   Milan Roubal
   roubm9am na barbora.ms.mff.cuni.cz

----- Original Message -----
From: "POLÁČEK Petr" <petr.polacek na hus.br.ds.mfcr.cz>
To: <databases na linux.cz>
Sent: Friday, November 16, 2001 11:50 AM
Subject: RE: postgres 7.1.2 a trideni CH


> >
> > Me to beha - viz
> > test=# create table trid(text varchar);
> > CREATE
> > test=# insert into trid (text) values ('humac');
> > INSERT 72465 1
> > test=# insert into trid (text) values ('chabada');
> > INSERT 72466 1
> > test=# insert into trid (text) values ('ikona');
> > INSERT 72467 1
> > test=# select * from trid;
> >   text
> > ---------
> >  humac
> >  chabada
> >  ikona
> > (3 rows)
>
> Rekl bych, ze toto mate setridene dobra proto, ze vam v dotazu chyby
"order
> by text" a tak je to vypsano v tom poradi, v jakem jste to zadaval. A
shodou
> okolnosti jste ty inserty udelal v abecednim poradi. Mechanismus trideni
se
> tedy vubec neuplatnil.
>
> Petr Polacek
> Spravce IS FU v Hustopecich



Další informace o konferenci Test