Re: [GENERAL] Access a Field / Column of a resultset by Number

2009-11-29 Thread A. Kretschmer
In response to Daniel Schuchardt : > hy group, > > i currently look for a solution to access a resultset in a db-stored > function by number. in plpgsql thats not possible. Can you wait until 8.5? http://okbob.blogspot.com/2009/10/dynamic-access-to-record-fields-in.html Regards, Andreas --

Re: [GENERAL] Access a Field / Column of a resultset by Number

2009-11-28 Thread Daniel Schuchardt
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 abou

Re: [GENERAL] Access a Field / Column of a resultset by Number

2009-11-27 Thread Scott Marlowe
On Fri, Nov 27, 2009 at 10:09 AM, Daniel Schuchardt 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 list

[GENERAL] Access a Field / Column of a resultset by Number

2009-11-27 Thread Daniel Schuchardt
hy group, i currently look for a solution to access a resultset in a db-stored function by number. in plpgsql thats not possible. so i checked out plpython. so far so good, thats working: CREATE OR REPLACE FUNCTION dokv_dorecnokeywords(sqlstatement VARCHAR) RETURNS VOID AS $$ rv = plpy.exec

Re: [GENERAL] Access a Field / Column of a resultset by Number

2009-11-27 Thread Daniel Schuchardt
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.