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'; -

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 va

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 i

[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