Hi!
I am receiving the following error when trying to execute sql
Error: ERROR: ExecSubPlan: failed to find placeholder for subplan
result (State:HY000, Native Code: 2C)
-
My query works fine in Oracle database without any issues.
I have sub queries w
"Kota, Prasoona" <[EMAIL PROTECTED]> writes:
> I am receiving the following error when trying to execute sql
> Error: ERROR: ExecSubPlan: failed to find placeholder for subplan
What Postgres version is that? If it's not a current minor release,
please try updating, because I seem to remember hav
Ruben Gouveia wrote:
v_where varchar(256) := 'where m.jb_date < '||p_date + integer '1'||
' and m.jb_date >='||p_date||'';
Try wrapping your p_date in a quote_literal like
...
'where m.jb_date < '||quote_literal(p_date+INTEGER '1')||' and ...
eg.
CREATE OR REPL
Ruben Gouveia wrote:
Is that more expensive to run than just useing a bunch of ticks?
Try wrapping your p_date in a quote_literal like
...
'where m.jb_date < '||quote_literal(p_date+INTEGER '1')||' and ...
I personally have never noticed any increased overhead from quote_literal.
--
Sent vi
Bricklen Anderson <[EMAIL PROTECTED]> writes:
> Ruben Gouveia wrote:
>> Is that more expensive to run than just useing a bunch of ticks?
> I personally have never noticed any increased overhead from quote_literal.
Much more important is that you'll reliably get the right answer.
i will try that. thank you
On Wed, Sep 10, 2008 at 11:45 AM, Tom Lane <[EMAIL PROTECTED]> wrote:
> Bricklen Anderson <[EMAIL PROTECTED]> writes:
> > Ruben Gouveia wrote:
> >> Is that more expensive to run than just useing a bunch of ticks?
>
> > I personally have never noticed any increased overh
Good afternoon,
I have a question about pg_restore in JAVA and need your help.
I planed to do:
==
1. pg_dump each tables (done successfully)
2. start a java connection
auto_commit = false
3.for(Table1... ... TableN)
{
drop primary key
pg_restore table (dead lock
Is that more expensive to run than just useing a bunch of ticks?
Sent from Apple iPhone 3G
On Sep 10, 2008, at 11:24 AM, Bricklen Anderson
<[EMAIL PROTECTED]> wrote:
Ruben Gouveia wrote:
v_where varchar(256) := 'where m.jb_date < '||p_date + integer
'1'||
I tried to do the following and got the following error message:
select employee,count(distinct tasks)
from job
where greatest(max(last_job_date),max(last_position_date)) <
2008-08-28 + integer '1'
group by employee;
ERROR: aggregates not allowed in WHERE clause
On Wed, 10 Sep 2008, Ruben Gouveia wrote:
> I tried to do the following and got the following error message:
>
> select employee,count(distinct tasks)
> from job
> where greatest(max(last_job_date),max(last_position_date)) <
> 2008-08-28 + integer '1'
> group by employee;
>
On Wed, Sep 10, 2008 at 4:11 PM, Ruben Gouveia <[EMAIL PROTECTED]> wrote:
> select employee,count(distinct tasks)
> from job
> where greatest(max(last_job_date),max(last_position_date)) <
> 2008-08-28 + integer '1'
> group by employee;
>
> ERROR: aggregates not allowed in
Emi Lu wrote:
Good afternoon,
I have a question about pg_restore in JAVA and need your help.
I planed to do:
==
1. pg_dump each tables (done successfully)
2. start a java connection
auto_commit = false
3.for(Table1... ... TableN)
{
drop primary key
pg_restore ta
12 matches
Mail list logo