Home > mailing lists

substitute variable in sql? - Mailing list pgsql-general

From	Johnson, Shaunn
Subject	substitute variable in sql?
Date	October 29, 2002 14:15:05
Msg-id	73309C2FDD95D11192E60008C7B1D5BB04C74131@snt452.corp.bcbsm.com Whole thread Raw
List	pgsql-general

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?

(Quiet as it's been kept, this looks like a

job for Perl ...)

Thanks!

-X

From: "Johnson, Shaunn"
Date: 29 October 2002, 13:24:59
Subject: ps_dump -a

From: Doug McNaught
Date: 29 October 2002, 14:19:30
Subject: Re: substitute variable in sql?