Re: substitute variable in sql?

From: Doug McNaught <doug(at)mcnaught(dot)org>
To: "Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: substitute variable in sql?
Date: 2002-10-29 16:19:31
Message-ID: m3wuo1fca4.fsf@varsoon.wireboard.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)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?

-Doug

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Johnson, Shaunn 2002-10-29 16:35:42 Re: substitute variable in sql?
Previous Message Johnson, Shaunn 2002-10-29 16:14:58 substitute variable in sql?