On Fri, 2003-09-05 at 14:18, Relaxin wrote: > Expect that the Declare/Fetch only creates a forwardonly cursor, you can go > backwards thru the result set.
No, DECLARE can create scrollable cursors, read the ref page again. This functionality is much improved in PostgreSQL 7.4, though. -Neil ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match