hy scott, thanks for your awnser.
yes thats clear. but i can't find any sourcecode. the pl* language
doesnt matter, i need that feature only in one function all over my db.
did you have any sourcecode examples?
http://www.postgresql.org/docs/8.4/interactive/plperl-database.html
nothing about how to access a column by fieldname.
daniel
Scott Marlowe schrieb:
On Fri, Nov 27, 2009 at 10:09 AM, Daniel Schuchardt
<d.schuchardt@xxxxxxxxxxxxx> wrote:
thats exactly the same i'm looking for:
http://wiki.postgresql.org/wiki/Todo
http://archives.postgresql.org/pgsql-patches/2005-07/msg00458.php
(todo list for plpgsql)
*Server-Side Languages
*PL/pgSQL
*
*[D] Allow listing of record column names, and access to record columns *via
variables, e.g. columns := r.(*), tval2 := r.(colname)
*
*Re: PL/PGSQL: Dynamic Record Introspection
is that is possible in any pl* language?
Yes, if the language has the architecture to handle it. plpgsql
doesn't right now. pltcl, plperl, and plain old C functions can
examine records and do dynamic stuff with them. Any attempt at doing
dynamic queries right now in plpgsql leads to madness, or so I've been
told.
--
Daniel Schuchardt
/Softwareentwicklung/
/http://www.prodat-sql.de/
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
