Re: "record" datatype - plpgsql

From: Sean Chittenden <sean(at)chittenden(dot)org>
To: Brian Knox <laotse(at)aol(dot)net>
Cc: George Weaver <georgew1(at)mts(dot)net>, pgsql-sql(at)postgresql(dot)org
Subject: Re: "record" datatype - plpgsql
Date: 2003-05-30 17:12:38
Message-ID: 20030530171238.GL62688@perrin.int.nxad.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> > 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2003-05-30 17:51:49 Re: CASE returning multiple values (was SQL Help)
Previous Message Franco Bruno Borghesi 2003-05-30 17:12:30 Re: SQL Help