Skip to content

Instantly share code, notes, and snippets.

@kmoppel

kmoppel/alpha_sorting.sql

Last active August 17, 2017 06:53
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save kmoppel/4dc0a68ac2d95a2b3b69eb710a8f8343 to your computer and use it in GitHub Desktop.
Save kmoppel/4dc0a68ac2d95a2b3b69eb710a8f8343 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
alpha_sorting.sql
CREATE TABLE alpha (
s text
);
insert into alpha select 'Volk';
insert into alpha select '(Weiter) A';
insert into alpha select '(Weiter) B';
insert into alpha select 'WISO';
insert into alpha select 'Zahn';
krl@postgres=# select s from alpha order by s;
s
────────────
Volk
(Weiter) A
(Weiter) B
WISO
Zahn
(5 rows)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment