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
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
