[GENERAL] Postgres PL SQL bug?

2005-03-31 Thread Shaun Clements
Hi All Im hoping someone has an answer for this mystery. I have a stored procedure, which queries a table, of about 400-000 records, into a RECORD, ordered by three columns. I am using a conditional INSERT, UPDATE command, basedon evaluating the last record.column, against the new

Re: [GENERAL] Postgres PL SQL bug?

2005-03-31 Thread Richard Huxton
Shaun Clements wrote: The problem is the records are not ORDERED properly into the RECORD, and when looping through it,it is trying to INSERT somewhere down the line, and is returning an error, saying it cant INSERT a duplicate key into unique.. etc. What do you mean by not ordered properly? How