From: | Srikanth Kata <srikanth(at)inventum(dot)net> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Cant execute the query |
Date: | 2010-07-02 12:24:30 |
Message-ID: | 29055726.post@talk.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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
--
View this message in context: http://old.nabble.com/Cant-execute-the-query-tp29055726p29055726.html
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | Trinath Somanchi | 2010-07-05 05:57:41 | How to store Byte strings into a table. |
Previous Message | Dmitriy Igrishin | 2010-07-02 09:15:21 | Domains based on composite types. |