Re: [SQL-Ledger-users] Re: SQL update statement

[John C. L. N. <nj...@nt...>]

John O'Gorman wrote:
> 
> To selectively update rows: (I have made up column and table names)
> 
> UPDATE tx
>         SET (balance )= (SELECT expr from .... WHERE )
> WHERE txdate between today - 7 and today
> 
> Note the 'today' is appropriate for Informix. There will be an
> equivalent in PostgreSQL.

now() or CURRENT_DATE variable, I think....;-)


-- 
     /) John Clark Naldoza y Lopez                           (\
    / )    Software Design Engineer II                       ( \
  _( (_    _  Web-Application Development                    _) )_
 (((\ \>  /_>    Cable Modem Network Management System <_\  </ /)))
 (\\\\ \_/ /         NEC Telecom Software Phils., Inc.  \ \_/ ////)
  \       /                                              \       /
   \    _/  phone: (+63 32) 233-9142 loc. 3112            \_    /
   /   /  cellphone: (+63 919) 399-4742                     \   \
  /   / email: nj...@nt...                        \   \