Re: Using scalar function as set-returning: bug or feature?

From: Sergei Kornilov <sk(at)zsrv(dot)org>
To: Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Using scalar function as set-returning: bug or feature?
Date: 2018-02-09 07:47:41
Message-ID: 991471518162461@web54j.yandex.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello

> select into b from my_insert('from func atx');
You missed select something into b. For example,
select ret into b from my_insert('from func atx') as ret;

Using scalar function in from is not bug.
Silent assigning NULL for variables in "into" not matches same in "select"... I think better would be raise warning.

regards, Sergei

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Garym 2018-02-09 07:56:00 Is there a cache consistent interface to tables ?
Previous Message Masahiko Sawada 2018-02-09 07:34:27 Re: Temporary tables prevent autovacuum, leading to XID wraparound