[GENERAL] how to return 0 rows in function

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

[GENERAL] how to return 0 rows in function

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

Re: [GENERAL] how to return 0 rows in function

Tomas Macek wrote: 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

Re: [GENERAL] how to return 0 rows in function

Am Freitag, 18. Mai 2007 10:20 schrieb Tomas Macek: 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

Re: [GENERAL] how to return 0 rows in function

On Fri, 18 May 2007, Richard Huxton wrote: Tomas Macek wrote: 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';