"Yury Peskin" <ypeskin(at)cycle-inc(dot)com> wrote:
> ERROR: query has no destination for result data
> HINT: If you want to discard the results of a SELECT, use
> PERFORM instead.
> CONTEXT: PL/pgSQL function "nm_create_friend" line 3 at
> SQL statement
> CREATE FUNCTION nm_create_friend(user_id uuid, friend_id
> text) RETURNS void
> LANGUAGE plpgsql
> AS $_$
> SELECT f.friend_id
> friends AS f
> WHERE f.user_id = $1 AND f.friend_id = $2;
> IF NOT FOUND THEN
> INSERT INTO friends (user_id, friend_id) values($1,$2);
> END IF;
> For some reason, psql thinks that PERFORM
> NM_create_friend($1, friend_id); function is using a
No, it thinks that within the nm_create_friend() function there is a
SELECT which isn't assigning the value to anything. And it's right.
It subsequently shows you where that function is being called from,
but that's not as relevant.
> Any ideas on how to fix this issue?
The HINT says it all.
In response to
pgsql-novice by date
|Next:||From: Tom Browder||Date: 2012-09-19 16:33:11|
|Subject: Upgrade and Single User|
|Previous:||From: Yury Peskin||Date: 2012-09-18 18:47:37|
|Subject: Issue with PERFORM|