pg.ddx.io pgsql-interfaces@postgresql.org mailing list archivehelp / color / mirror / Atom feed
pl/pythonu - return values 2+ messages / 2 participants [nested] [flat]
* pl/pythonu - return values @ 2005-10-19 19:03 Kelly Burkhart <kelly@tradebotsystems.com> 0 siblings, 1 reply; 2+ messages in thread From: Kelly Burkhart @ 2005-10-19 19:03 UTC (permalink / raw) To: pgsql-interfaces Can pl/pythonu procedures return anything other than a string? I have some python code which communicates to another process and can either return sensible results or some kind of error. I was hoping to return something like: create type rval_t as (status integer, status_txt text, result text); Is something like this possible? ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: pl/pythonu - return values @ 2005-10-19 22:45 Joshua D. Drake <jd@commandprompt.com> parent: Kelly Burkhart <kelly@tradebotsystems.com> 0 siblings, 0 replies; 2+ messages in thread From: Joshua D. Drake @ 2005-10-19 22:45 UTC (permalink / raw) To: Kelly Burkhart <kelly@tradebotsystems.com>; +Cc: pgsql-interfaces Kelly Burkhart wrote: >Can pl/pythonu procedures return anything other than a string? > >I have some python code which communicates to another process and can >either return sensible results or some kind of error. I was hoping to >return something like: > >create type rval_t as (status integer, status_txt text, result text); > > Well you could have it return the set using a setof function. >Is something like this possible? > > >---------------------------(end of broadcast)--------------------------- >TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match > > -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/ ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2005-10-19 22:45 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2005-10-19 19:03 pl/pythonu - return values Kelly Burkhart <kelly@tradebotsystems.com> 2005-10-19 22:45 ` Joshua D. Drake <jd@commandprompt.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox