Yes you can make a procedure call in a trigger function.
Example
Trigger block
{
PERFORM Procedure();
}
Regards.
Ram
- Original Message -
From: "Scott Marlowe"
To: "Doug Pisarek"
Cc:
Sent: Thursday, August 20, 2009 9:31 AM
Subject: Re: [SQL] Call Procedure From Trigger Function
On Wed, Aug 19, 2009 at 3:53 PM, Doug Pisarek wrote:
> I am in the process of coverting an Oracle 10.2.0.3 database to Postgresql
> 8.3. I have a number of triggers in Oracle that make a call to packages.
> I know I will need to re-write the Oracle packages to postgres functions.
> The issue which
I am in the process of coverting an Oracle 10.2.0.3 database to
Postgresql 8.3. I have a number of triggers in Oracle that make a call
to packages.
I know I will need to re-write the Oracle packages to postgres
functions. The issue which I have can I make a procedure call from
inside a postgres tri
Hello Craig, list
Is there a way to have two or more connections see each others
uncommitted things?
Not at present.
You should be able to use explicitly declared cursors and FETCH to
interleave requests for results from one or more queries in the same
transation using the one connection, bu
The bitmask allows the setting of multiple permissions but the table
definition doesn't have to change (well, so long as the bits fit into a
word!) Finally, this is a message forum - the actual code itself is
template-driven and the bitmask permission structure is ALL OVER the
templates; gettin
Hello,
I would try to replace the loop with a single UPDATE FROM Statement:
Update EP_ES06_N_TEMP2
Set
FROM (
select
kodedivisi,kodeseksi,kodewip,nobatch,ket1,ket2,ket3,ket4,NILAIPROP as
nilaiygdibagi
from EDP040_07_23
--order by
kodedivisi,kodeseksi,k
On Wed, Aug 19, 2009 at 05:17:07PM +0700, Otniel Michael wrote:
>Hi All.
>
>Can help to create sql queries for this data :
>
>tabel A
>field1, field2, field3
>x1, y1, 5
>x1, y2, 1
>x2, y1, 2
>x2, y3, 4
>x1, y3, 4
>
>
In response to Otniel Michael :
> Hi All.
>
> Can help to create sql queries for this data :
>
> tabel A
> field1, field2, field3
> x1, y1, 5
> x1, y2, 1
> x2, y1, 2
> x2, y3, 4
> x1, y3, 4
>
> I want to get 2 record with the max value at field3 for each k
Hi All.
Can help to create sql queries for this data :
tabel A
field1, field2, field3
x1, y1, 5
x1, y2, 1
x2, y1, 2
x2, y3, 4
x1, y3, 4
I want to get 2 record with the max value at field3 for each kombination of
field1 :
tabel B
field1, field2, field3
x1,
Hi guys, can anyone help to optimize this loop :
for i in
select
kodedivisi,kodeseksi,kodewip,nobatch,ket1,ket2,ket3,ket4,NILAIPROP as
nilaiygdibagi
from EDP040_07_23
order by kodedivisi,kodeseksi,kodewip,nobatch,ket1,ket2,ket3,ket4
loop
jmlData2 = jmlData2
10 matches
Mail list logo
