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