Re: How return a row from a function so it is recognized as such by caller?

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: Kenneth Tilton <ktilton(at)mcna(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: How return a row from a function so it is recognized as such by caller?
Date: 2012-03-28 19:40:20
Message-ID: CAHyXU0w+y=Fz5Vod9yhGxgx4cFE2Q4TBeqm75rEwYMTmSK8rPg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Mar 28, 2012 at 2:08 PM, Kenneth Tilton <ktilton(at)mcna(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kenneth Tilton 2012-03-28 19:49:46 Re: How return a row from a function so it is recognized as such by caller?
Previous Message Kenneth Tilton 2012-03-28 19:08:21 Re: How return a row from a function so it is recognized as such by caller?