To: pgsql-sql@postgresql.org
From: Thomas Kellerer <spam_eater@gmx.net>
Subject: Re: Cant execute the query
Date: Fri, 09 Jul 2010 00:08:37 +0200
Lines: 37
Message-ID: <i15i95$ksu$1@dough.gmane.org>
References: <29055726.post@talk.nabble.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; de;
	rv:1.8.1.21) Gecko/20090302 Thunderbird/2.0.0.21 Mnenhy/0.7.5.666
In-Reply-To: <29055726.post@talk.nabble.com>

Srikanth Kata wrote on 02.07.2010 14:24:
>
> When i am executing this query, i am facing the
>   select
> s.*,a.actid,a.phone,d.domid,d.domname,d.domno,a.actno,a.actname,p.descr as
> svcdescr from vwsubsmin s
> inner join packages p on s.svcno=p.pkgno
> inner join account a on a.actno=s.actno
> inner join ssgdom d on a.domno=d.domno
> inner join (select subsno from getexpiringsubs($1,cast($2 as
> integer),cast($3 as double precision),$4) as (subsno int,expirydt timestamp
> without time zone,balcpt double precision)) as e on s.subsno=e.subsno
> where s.status<=15 and d.domno=$5
> order by d.domname,s.expirydt,a.actname
>
>
>
> Error is :
>
> ERROR:  there is no parameter $1
> LINE 5: inner join (select subsno from getexpiringsubs($1,cast($2 as...
>                                                         ^
>
> ********** Error **********
>
> ERROR: there is no parameter $1
> SQL state: 42P02
> Character: 295
>
>
>
> Please suggest on this

What about the answers you got here?

http://www.dbforums.com/postgresql/1658082-cant-execute-query.html
http://old.nabble.com/Unable-to-run-this-query-td29073430.html#a29073430