Stories
Slash Boxes
Comments
NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

All the Perl that's Practical to Extract and Report

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
 Full
 Abbreviated
 Hidden
More | Login | Reply
Loading... please wait.
  • by Matts (1087) on 2004.11.11 10:25 (#35933) Journal
    One of the main ways to use this in MS-SQL is to create a temp table, insert a bunch of things into it (in a way that you couldn't easily do with one statement) and then return the recordset of the temp table.

    Unfortunately temp tables have long been broken in Pg functions, because the function caches the table-id even for temp tables (it can't distinguish between temp and non-temp tables) and tries to re-use the old table-id next time around. Of course things break then because the table doesn't exist any more!

    I keep hoping this will be fixed. I haven't tried the most recent version (8?) of Pg though.