Re: Issue with PERFORM

From: Bartosz Dmytrak <bdmytrak(at)gmail(dot)com>
To: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: Yury Peskin <ypeskin(at)cycle-inc(dot)com>, pgsql-novice(at)postgresql(dot)org
Subject: Re: Issue with PERFORM
Date: 2012-09-21 14:44:34
Message-ID: CAD8_Ucb9DmQEC1PoB=SKY2uzAX0GTsM6EzQZFn+56R_7NgXM9g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi,
Problem is inside nm_create_friend(uuid, text) - return type is VOID but
there is a SELECT inside. There is no "space" for produced rows.

My suggestion is to add record variable and use SELECT INTO then check if
vairalble is empty or not.

Regards,
Bartek

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Browder 2012-09-21 15:03:06 Re: Upgrade and Single User
Previous Message Bartosz Dmytrak 2012-09-21 14:38:42 Re: Upgrade and Single User