From 43e20d081ed2f7fde35f19818432b38f423ef8be Mon Sep 17 00:00:00 2001 From: Norbert Moutarde Date: Sat, 13 Jul 2013 13:51:48 +0200 Subject: [PATCH] added "order by id" to mem func --- alias.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/alias.sql b/alias.sql index 266c6ba..4237b80 100644 --- a/alias.sql +++ b/alias.sql @@ -5,7 +5,7 @@ INSERT INTO alias (nom, command, argc) VALUES ('search', 'select id,texte from r INSERT INTO alias (nom, command, argc) VALUES ('rm', 'DELETE FROM raw WHERE id =$1;', 1); INSERT INTO alias (nom, command, argc) VALUES ('alias', 'select nom from alias;', 0); insert into alias (nom, command, argc) values ('var', 'select nom from var', 0); -insert into alias (nom, command, argc) values ('var', 'select id,nom,value from var where nom=$1', 1); +insert into alias (nom, command, argc) values ('var', 'select id,nom,value from var where nom=$1 order by id', 1); insert into alias (nom, command, argc, inf) values ('memo', 'insert into memo (word, rem) values ($1, $2);', 1, '1'); insert into alias (nom, command, argc) values ('memo', 'select distinct word from memo', 0); -insert into alias (nom, command, argc) values ('mem', 'select rem from memo where word=$1', 1); +insert into alias (nom, command, argc) values ('mem', 'select id,rem from memo where word=$1 order by id', 1); -- 2.45.1