Skip to content
Snippets Groups Projects
  1. Mar 22, 2002
  2. Mar 06, 2002
  3. Jan 23, 2002
  4. Nov 21, 2001
  5. Nov 19, 2001
  6. Oct 13, 2001
  7. Sep 13, 2001
  8. Sep 10, 2001
  9. Aug 02, 2001
    • Bruce Momjian's avatar
      I noticed that pltcl didn't have any way to get to SPI_lastoid like plpgsql... · 84d2c518
      Bruce Momjian authored
      I noticed that pltcl didn't have any way to get to SPI_lastoid like plpgsql does.. I started using pltcl a lot because I like to decide when and how my queries get planned.. so I put one together really quick
      
      Sorry I don't have the original around to make a quick diff, but its a very small change... I think this should be in the next release, there's no reason not to have it.
      
      its a function with no expected arguments, so you can use it like:
      spi_exec "INSERT INTO mytable(columns...) VALUES(values..)"
      set oid [spi_lastoid]
      spi_exec "SELECT mytable_id from mytable WHERE oid=$oid"
      
      It just didn't make sense for me to use plpgsql and pltcl, or just screw
      them both and use SPI from C.
      
      
      bob@redivi.com
      84d2c518
  10. Jun 09, 2001
  11. May 13, 2001
  12. May 01, 2001
  13. Mar 25, 2001
  14. Feb 09, 2001
  15. Sep 29, 2000
  16. Aug 25, 2000
  17. May 18, 2000
  18. Mar 31, 2000
Loading