Pseudo code:
begin trans
select * from table1
WAIT FOR 20 SECS
update table1 set blah = 'blah'
end transcation
In pgplsql, Im looking for something like a function that I can use to make the
process to wait for 20 secs before continuing to execute the next sql statment?
Thanks,
Girish
-
ge-
From: Josh Berkus [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 17, 2003 2:03 PM
To: Richard Huxton; Girish Bajaj; [EMAIL PROTECTED]
Subject: Re: [SQL] Table Partitioning and Rules
Girish,
> > Essentially Im trying to store a persons information in a table in the
> > database. S
Hello All,
I have a set of tables partitioned horizontally. DML below.
Essentially Im trying to store a persons information in a table in the
database. Since we could have millions of people, with duplicates! Ive decided
we need to partition the table into segments where all people
