Postgres Pro
Downloads
Home   >   mailing lists

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

From Vyacheslav Kalinin
Subject Re: How to pass parameters into a sql script ?
Date
Msg-id 9b1af80e0905280910x248b2467u35f2c063915a8224@mail.gmail.com
Whole thread Raw
In response to How to pass parameters into a sql script ?  ("Atul Chojar" <achojar@airfacts.com>)
Responses Re: How to pass parameters into a sql script ?  ("Atul Chojar" <achojar@airfacts.com>)
List pgsql-admin
Tree view
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';...


pgsql-admin by date:

Previous
From: "Atul Chojar"
Date:
Subject: How to pass parameters into a sql script ?
Next
From: Ibrahim Shaame
Date:
Subject: Cannot compile pgadmin3-1.10.0-beta3