OpenACS

lars
committed
MAIN:lars:20030818104055
on 18 Aug 03
Fixing PG 7.3 incompatibility problem -- pulled over from oacs-4-6 branch
/www/item-create-postgresql.xql (+1 -1)
1 1 <?xml version="1.0"?>
2 2
3 3 <queryset>
4 4    <rdbms><type>postgresql</type><version>7.1</version></rdbms>
5 5
6 6 <fullquery name="week">     
7 7       <querytext>
8         select current_timestamp + [ad_parameter ActiveDays "news" 14]
  8       select to_char(current_timestamp + interval '[ad_parameter ActiveDays "news" 14] days', 'YYYY-MM-DD')
9 9       </querytext>
10 10 </fullquery>
11 11
12 12  
13 13 </queryset>