Postgres Pro
Downloads
Home   >   mailing lists

Re: Issue with PERFORM - Mailing list pgsql-novice

From Bartosz Dmytrak
Subject Re: Issue with PERFORM
Date
Msg-id CAD8_Ucb9DmQEC1PoB=SKY2uzAX0GTsM6EzQZFn+56R_7NgXM9g@mail.gmail.com
Whole thread Raw
In response to Re: Issue with PERFORM  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: Issue with PERFORM
List pgsql-novice
Tree view

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

pgsql-novice by date:

Previous
From: Bartosz Dmytrak
Date:
Subject: Re: Upgrade and Single User
Next
From: Tom Browder
Date:
Subject: Re: Upgrade and Single User