> > What I was asking is if there's anyway to use the NEW record to > > get a list of the columnnames in it without knowing them > > beforehand. > > Not in plpgsql ... and if you did, you couldn't do anything useful > with the names (like access the fields) anyway. I believe you can > do it in pltcl though.
If you're shopping around for pl languages, pl/ruby fits the bill too. Reflective language with dynamic execution. -sc http://moulon.inra.fr/ruby/plruby.html -- Sean Chittenden ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html