| From: | c k <shreeseva(dot)learning(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | PERFORM |
| Date: | 2009-02-22 21:44:17 |
| Message-ID: | d8e7a1e30902221344l43336597yd17e27f56c51bfab@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello,
I have a small problem following statement executes well do not give me
proper results, rather subquery calleing another function is not executed at
all.
*perform sometable.pk, (select * from somefunction) from sometable where
somecondition;*
But* select * from somefunction;* and *perform * from somefunction*; and
also* select sometable.pk, (select * from somefunction) from sometable where
somecondition;* gets executed properly with all side effects.
Is there anything wrong in my first statement? OR perform can not used to
make join as in selects.
Thanks,
CPK
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2009-02-22 23:07:00 | Re: question on viewing dependencies |
| Previous Message | Devrim GÜNDÜZ | 2009-02-22 20:32:59 | Re: Mammoth replicator |