Postgres Pro
Downloads
Home   >   mailing lists

Re: How to pass parameters into a sql script ? - Mailing list pgsql-admin

From Atul Chojar
Subject Re: How to pass parameters into a sql script ?
Date
Msg-id 008f01c9dfbf$05b1dd60$11159820$@com
Whole thread Raw
In response to Re: How to pass parameters into a sql script ?  (Vyacheslav Kalinin <vka@mgcp.com>)
Responses How to automatically propagate new/changed database functions from one database to another
List pgsql-admin
Tree view

Thanks - with quoting, the 2nd select (select count(*) from prod_debit_payments_unapplied where when_received = :p_date;) works.

 

Thanks!

atul

AirFacts, Inc. 8120 Woodmont Ave., Suite 700 Bethesda, MD 20814 Tel: 301-760-7315

 

 

From: Vyacheslav Kalinin [mailto:vka@mgcp.com]
Sent: Thursday, May 28, 2009 12:10 PM
To: Atul Chojar
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] How to pass parameters into a sql script ?

 

Looks like quoting issue.
Try this one:

$ psql -d us_audit -e -1 -v p_date=\'20081023\' -f chk_param.sql
select count(*) from prod_debit_payments_unapplied where when_received = (select :p_date::char(8));

or even

select count(*) from prod_debit_payments_unapplied where when_received = :p_date;

On Thu, May 28, 2009 at 6:57 PM, Atul Chojar <achojar@airfacts.com> wrote:

We are unable to pass parameters into any sql script. Could anyone look at the test below and give any suggestions? PostgreSQL version is 8.2.7, running on Linux.

 

Test Script

========

$ cat chk_param.sql

select ''''||:p_date::char(8)||'''';

select count(*) from prod_debit_payments_unapplied where when_received = (select ''''||:p_date::char(8)||'''');

select count(*) from prod_debit_payments_unapplied where when_received = '20081023';

...

 

No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.5.339 / Virus Database: 270.12.40/2135 - Release Date: 05/28/09 08:10:00

Attachment

pgsql-admin by date:

Previous
From: Ibrahim Shaame
Date:
Subject: Cannot compile pgadmin3-1.10.0-beta3
Next
From: Anj Adu
Date:
Subject: Pre-creating partitions incurs insert penalty