Help for this page

Select Code to Download


  1. or download this
       my $sql=<<"_SQL_";
        SELECT cl_plugins.pid_number as pid, plugin_catalog.pid AS plugin_
    +name,
    ...
              AND cl_plugins.pid_number    = plugin_catalog.pid_number
              AND cl_plugins.version::text = plugin_catalog.version::text;
    _SQL_
    
  2. or download this
    my $sql=<<"__SQL__";
    SELECT 
    ...
    where pp.SUBMITTIME between '2014-06-26 05:00' and '2014-06-26 08:00:0
    +0' 
    order by pp.SUBMITTIME
    __SQL__