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);
|
