Re: How return a row from a function so it is recognized as such by caller? - Mailing list pgsql-general

From Merlin Moncure
Subject Re: How return a row from a function so it is recognized as such by caller?
Date
Msg-id CAHyXU0w+y=Fz5Vod9yhGxgx4cFE2Q4TBeqm75rEwYMTmSK8rPg@mail.gmail.com
Whole thread Raw
In response to Re: How return a row from a function so it is recognized as such by caller?  (Kenneth Tilton <ktilton@mcna.net>)
Responses Re: How return a row from a function so it is recognized as such by caller?
List pgsql-general
On Wed, Mar 28, 2012 at 2:08 PM, Kenneth Tilton <ktilton@mcna.net> wrote:
> Thanks, Merlin. Maybe I have some subtle detail wrong. When
> NEW.warn_time_init is 'now_plus_30' and I have this as my execute statement:
>
>         execute NEW.warn_time_init || '($1)' into bpa using NEW;
>
> ...I get:
>

your'e missing a 'select' in there.  functions must be called through
select (just like you can't call a function by name in psql without
it).

merlin

pgsql-general by date:

Previous
From: Kenneth Tilton
Date:
Subject: Re: How return a row from a function so it is recognized as such by caller?
Next
From: Kenneth Tilton
Date:
Subject: Re: How return a row from a function so it is recognized as such by caller?