Re: Using scalar function as set-returning: bug or feature? - Mailing list pgsql-hackers

From Sergei Kornilov
Subject Re: Using scalar function as set-returning: bug or feature?
Date
Msg-id 991471518162461@web54j.yandex.ru
Whole thread Raw
In response to Using scalar function as set-returning: bug or feature?  (Konstantin Knizhnik <k.knizhnik@postgrespro.ru>)
Responses Re: Using scalar function as set-returning: bug or feature?
List 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


pgsql-hackers by date:

Previous
From: Masahiko Sawada
Date:
Subject: Re: Temporary tables prevent autovacuum, leading to XID wraparound
Next
From: Garym
Date:
Subject: Is there a cache consistent interface to tables ?