[Refdb-cvs] CVS: refdb/src refdbdbib.c,1.36.2.12,1.36.2.13

[Markus H. <mho...@us...>]

Update of /cvsroot/refdb/refdb/src
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv1787/src

Modified Files:
      Tag: Release_0_9_5_stable
	refdbdbib.c 
Log Message:
added sorted_pos to SELECT DISTINCT query to pacify PostgreSQL

Index: refdbdbib.c
===================================================================
RCS file: /cvsroot/refdb/refdb/src/refdbdbib.c,v
retrieving revision 1.36.2.12
retrieving revision 1.36.2.13
diff -u -U2 -r1.36.2.12 -r1.36.2.13
--- refdbdbib.c	28 Sep 2004 22:14:40 -0000	1.36.2.12
+++ refdbdbib.c	25 Nov 2004 21:38:59 -0000	1.36.2.13
@@ -1501,5 +1501,5 @@
 
   /* select all unique author_abbrevlists */
-  sprintf(sql_command, "SELECT DISTINCT author_abbrevlist,pubyear FROM %s WHERE sorted_pos>0 ORDER BY sorted_pos", table_name);
+  sprintf(sql_command, "SELECT DISTINCT author_abbrevlist,pubyear, sorted_pos FROM %s WHERE sorted_pos>0 ORDER BY sorted_pos", table_name);
   LOG_PRINT(LOG_DEBUG, sql_command);
   dbires1 = dbi_conn_query(ptr_bibconns->conn, sql_command);