Re: [SQL] Updating a specific number of rows in pl/pgsql

> Unfortunately, there is no single column that provides a unique id. Correction - I did not understand what ctid was, but now I do, so I will try your tip. -- Peter Headland Architect Actuate Corporation -Original Message- From: Peter Headland Sent: Tuesday, August 11, 2009 10

Re: [SQL] Updating a specific number of rows in pl/pgsql

a new index) for performance reasons. Given that additional constraint, is my original plan using a loop to iterate over a cursor reasonable? I don't anticipate p_number_of_items being more than 20. -- Peter Headland Architect Actuate Corporation -Original Message- Fro

Re: [SQL] Updating a specific number of rows in pl/pgsql

>Assuming that there is a unique identifier on queue Alas, there is not. The PK is made up of 4 columns. -- Peter Headland Architect Actuate Corporation -Original Message- From: D'Arcy J.M. Cain [mailto:da...@druid.net] Sent: Tuesday, August 11, 2009 03:25 To: Peter Headland C

[SQL] Updating a specific number of rows in pl/pgsql

g like: UPDATE (SELECT ... ) ... -- Peter Headland Architect Actuate Corporation

[SQL] Best way to simulate Booleans

... -- Peter Headland Architect - e.Reports Actuate Corporation