... - Mailing list pgsql-general

From Tomas Macek
Subject ...
Date
Msg-id alpine.LFD.0.99.0705181006440.12374@maca.fortech.cz
Whole thread Raw
List pgsql-general
Hi, I have simplified function like this:

----------------
CREATE OR REPLACE FUNCTION f(varchar) RETURNS varchar AS $FUNC$
DECLARE
     addr ALIAS FOR $1;
BEGIN
     -- return NULL;
     -- return '';
END
$FUNC$ LANGUAGE 'plpgsql';
-----------------

This function is returning varchar and it always returns at least one row. How can I make it to return 0 rows? Is it
possibleor not and how? 
Returning NULL does not help (return NULL string in 1 row). Not to return a value leads to error output.

Many thanks for help

Tomas



pgsql-general by date:

Previous
From: Tomas Macek
Date:
Subject: how to return 0 rows in function
Next
From: Andreas
Date:
Subject: Re: Admin-Functions in Ubuntu's PG 8.2 missing?