Re: substitute variable in sql?

On Tue, Oct 29, 2002 at 11:19:31 -0500,
  Doug McNaught <doug@mcnaught.org> wrote:
> "Johnson, Shaunn" <SJohnson6@bcbsm.com> writes:
>
> > Running PostgreSQL 7.2.1 on RedHat Linux 7.2:
> >
> > I have a query where I have to replace the
> > date parameter each time I run the query.
> >
> > Is there a way to substitute just the date
> > parameter in the sql without having to
> > edit the script, re-run and edit again?
>
> There are loads of ways to do this.  What client language are you
> using?  Are you running 'psql' from a shell script?

And also what date do you want? It may be possible to calculate it based
on the current date and/or information in the database.