| From: | Tomas Macek <macek(at)fortech(dot)cz> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | |
| Date: | 2007-05-18 08:10:47 |
| Message-ID: | alpine.LFD.0.99.0705181006440.12374@maca.fortech.cz |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 possible or 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tomas Macek | 2007-05-18 08:20:41 | how to return 0 rows in function |
| Previous Message | Albe Laurenz | 2007-05-18 07:26:09 | Re: HowTo SSL probaply with ODBC ? |