Re: Problem with plpgsql function

Поиск
Список
Период
Сортировка
От Chris Bowlby
Тема Re: Problem with plpgsql function
Дата
Msg-id 1074193560.33449.13.camel@morpheus.hub.org
обсуждение исходный текст
Ответ на Re: Problem with plpgsql function  (Joe Conway <mail@joeconway.com>)
Список pgsql-sql
Ack, I knew it was something small, I was under the impression that I
had been using that, it just took someone to point it out to make me
look again :>... thanks..

On Thu, 2004-01-15 at 14:47, Joe Conway wrote:
> Chris Bowlby wrote:
> > select get_account_info('test.com');
> > 
> >  I get this error:
> > 
> > ERROR:  set-valued function called in context that cannot accept a set
> 
> This is the "classic" SRF error -- you need to use an SRF like a 
> relation in the FROM clause, so do this instead:
> 
>    select * FROM get_account_info('test.com');
> 
> HTH,
> 
> Joe
-- 
Chris Bowlby <excalibur@hub.org>
Hub.Org Networking Services



В списке pgsql-sql по дате отправления:

Предыдущее
От: Joe Conway
Дата:
Сообщение: Re: Problem with plpgsql function
Следующее
От: "Denis"
Дата:
Сообщение: Initially Deffered - FK