close Warning: Can't synchronize with repository "(default)" (/var/svn/tolp does not appear to be a Subversion repository.). Look in the Trac log for more information.

Changes between Version 3 and Version 4 of LeftMenu


Ignore:
Timestamp:
Feb 3, 2016, 10:47:13 AM (9 years ago)
Author:
Pedro Gea
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • LeftMenu

    v3 v4  
    2525#!sql
    2626UPDATE tolsch.wiki a
    27 SET text = regexp_replace(a.text, '<LEFT-MENU>.*</LEFT-MENU>', m.lmenu)
     27SET text = regexp_replace(a.text, '<LEFT-MENU>.*?</LEFT-MENU>', m.lmenu)
    2828FROM (
    2929  SELECT name, Max(version) as version
    … …  
    3232  GROUP BY name
    3333) av, (
    34   SELECT (regexp_matches(text, '<LEFT-MENU>.*</LEFT-MENU>'))[1] as lmenu
     34  SELECT (regexp_matches(text, '<LEFT-MENU>.*?</LEFT-MENU>'))[1] as lmenu
    3535  FROM tolsch.wiki b, (
    3636    SELECT Max(version) as version