Its considered bad form to post to multiple lists. Please pick the most
relevant one - in this case I'd suggest -general.
On Mon, Sep 26, 2016 at 8:39 AM, dby...@163.com wrote:
>
> Array is not convenient to use in function, whether
> there are other methods can be replaced temp table in functi
2016-09-26 17:39 GMT+02:00 dby...@163.com :
> test:
> create type h3 as (id int,name char(10));
>
> CREATE or replace FUNCTION proc17()
> RETURNS SETOF h3 AS $$
> DECLARE
> v_rec h3;
> BEGIN
> create temp table abc(id int,name varchar) on commit drop;
> insert into abc select 1,'lw';
> inser
On Mon, Sep 26, 2016 at 9:18 AM, 邓彪 wrote:
> we have to do dml in temp table,the CTE is not fit
>
>
Moving this to -general only...
Please direct all replies to the list.
You are asking for help but not providing any context for what your
requirements are. You are not likely to get good hel