Hi,
Why does log temp files are created twice when query is executed in PL/pgSQL
function?
Would you please explain it to me?
As below test result. Log temp files are created twice when SELECT statement is
put
into a PL/pgSQL function. It led a little of performance degradation.
Is there any
Hi,
Thanks for your prompt response.
Appreciate your help.
Thanks and best regards,
bocap
> Hi
>
> 2016-03-16 15:58 GMT+01:00 Dang Minh Huong :
>> Hi,
>>
>> Why does log temp files are created twice when query is executed in PL/pgSQL
>> function?
>> Wou
Thank you all for your support.
2013/11/15 3:40、Sergey Konoplev のメッセージ:
>> On Thu, Nov 14, 2013 at 7:13 AM, Dang Minh Huong wrote:
>> I am using PostgreSQL 9.1 and get a syntax error with the following PL/pgSQL
>> clause.
>> Is there any equivalent syntax
Hi,
2013/11/15 0:43、David Johnston のメッセージ:
> bocap wrote
(rec[1]).t1 := 1;
>
> You need to stay one-level higher and re-build the entire typ entry then
> assign it back to the array at the same position.
>
> rec[1] = (1, rec[1].t2)::typ;
>
Thanks. I think, i can solve it with this way.
Hi,
2013/11/15 0:38、Elliot のメッセージ:
>> On 2013-11-14 10:32, Dang Minh Huong wrote:
>> Hi,
>>
>> 2013/11/15 0:20、Elliot のメッセージ:
>>
>>>> On 2013-11-14 10:13, Dang Minh Huong wrote:
>>>> Hi all,
>>>>
>>>> I am using
Hi,
2013/11/15 0:20、Elliot のメッセージ:
>> On 2013-11-14 10:13, Dang Minh Huong wrote:
>> Hi all,
>>
>> I am using PostgreSQL 9.1 and get a syntax error with the following PL/pgSQL
>> clause.
>> Is there any equivalent syntax in PL/pgSQL to solve it.
>>
&
Hi all,
I am using PostgreSQL 9.1 and get a syntax error with the following PL/pgSQL
clause.
Is there any equivalent syntax in PL/pgSQL to solve it.
--
rec typ[];
(typ[1]).t1 := 1;
--
typ is type which was created by command below.
Create type typ as(
t1 interger,
t2 text);
I am migra
