> I could then do some queries against the temporary table without having to > regenerate the results every time I want to show a "Page 299 of 500" toolbar.
Performance wise temp tables are the same as a regular table but without WAL on the table contents. > Would I be better off just sucking this data into an in-memory data structure, > or can I use a temp table as an easy-to-use alternative? You are probably better off using a cursor. -- Rod Taylor <[EMAIL PROTECTED]> PGP Key: http://www.rbt.ca/rbtpub.asc
signature.asc
Description: This is a digitally signed message part