Re: using postgres functions for domain tables

2012-02-23 Thread Peter
On 23/02/12 23:32, Matthias Leopold wrote: > could you give me an example of how to do this? > right now i'm calling my function like > > select function('foo'); > or > select * from function('foo'); Give more details about what this function does and what output you expect from it. Peter

Re: using postgres functions for domain tables

2012-02-23 Thread Matthias Leopold
Am 2012-02-23 00:42, schrieb Peter: On 23/02/12 05:30, Matthias Leopold wrote: how do i make a postgres plperl function return a value/row only when certain conditions are met and otherwise return "nothing"/void/0 rows? right now my function returns "1 row" even when i return undef. Have you t

Re: using postgres functions for domain tables

2012-02-22 Thread Peter
On 23/02/12 05:30, Matthias Leopold wrote: > how do i make a postgres plperl function return a value/row only when > certain conditions are met and otherwise return "nothing"/void/0 rows? > right now my function returns "1 row" even when i return undef. Have you tried using your function in the WH

Re: using postgres functions for domain tables

2012-02-22 Thread k...@rice.edu
On Wed, Feb 22, 2012 at 05:30:02PM +0100, Matthias Leopold wrote: > hi, > > i want to use postgres (8.3) plperl functions to provide > virtual_mailbox_domains/relay_domains. > > is this possible? > > how do i make a postgres plperl function return a value/row only > when certain conditions are m

using postgres functions for domain tables

2012-02-22 Thread Matthias Leopold
hi, i want to use postgres (8.3) plperl functions to provide virtual_mailbox_domains/relay_domains. is this possible? how do i make a postgres plperl function return a value/row only when certain conditions are met and otherwise return "nothing"/void/0 rows? right now my function returns "1