Re: PostgreSQL 7.2 and SLQ-Ledger 6.x

[Jonas S. <dr...@jo...>]

On Thu, 7 Mar 2002, Keld Jørn Simonsen wrote:

> > A simple search and replace did the trick:
> >
> > s/'current_date'/CURRENT_DATE/
>
> I get a lot of errors
> invalid command \N
> invalid command \.
>
> And after doing your recommended change I get:
>
> ERROR:  Bad date external representation 'CURRENT_DATE'

My guess is you did this:

s/'current_date'/'CURRENT_DATE'/

instead of this:

s/'current_date'/CURRENT_DATE/

Notice the difference? Remove the quotes as well. :-)

 - Jonas

-- 
Jonas Smedegaard (+45 40843136)          http://dr.jones.dk/~jonas/
Spiff ApS (= IT-guide dr. Jones ApS)     http://dr.jones.dk/
Debian GNU/Linux developer               http://people.debian.org/~js/