Author: tille
Date: 2012-05-10 07:20:22 +0000 (Thu, 10 May 2012)
New Revision: 2302
Modified:
udd/sql/bibref.sql
Log:
Psql on UDD is picky about escaping strings ...
Modified: udd/sql/bibref.sql
===================================================================
--- udd/sql/bibref.sql 2012-05-10 03:00:36 UTC (rev 2301)
+++ udd/sql/bibref.sql 2012-05-10 07:20:22 UTC (rev 2302)
@@ -47,7 +47,7 @@
CASE WHEN bibpublisher.value IS NOT NULL THEN E',\n Publisher =
{' || bibpublisher.value || '}' ELSE '' END ||
CASE WHEN bibvolume.value IS NOT NULL THEN E',\n Volume = {' ||
bibvolume.value || '}' ELSE '' END ||
CASE WHEN bibnumber.value IS NOT NULL THEN E',\n Number = {' ||
bibnumber.value || '}' ELSE '' END ||
- CASE WHEN bibpages.value IS NOT NULL THEN E',\n Pages = {' ||
regexp_replace(bibpages.value, '(\d)-(\d)', '\1--\2') || '}' ELSE '' END ||
+ CASE WHEN bibpages.value IS NOT NULL THEN E',\n Pages = {' ||
regexp_replace(bibpages.value, E'(\\d)-([\\d])', E'\\1--\\2') || '}' ELSE ''
END ||
CASE WHEN biburl.value IS NOT NULL THEN E',\n URL = {' ||
replace(replace(replace(replace(biburl.value,
'_', E'\\_'), --
_______________________________________________
Collab-qa-commits mailing list
[email protected]
http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/collab-qa-commits
