Message-ID: <47CFAA53.7010309@archonet.com>
Date: Thu, 06 Mar 2008 08:24:51 +0000
From: Richard Huxton <dev@archonet.com>
User-Agent: Thunderbird 2.0.0.12 (X11/20080213)
MIME-Version: 1.0
To: Yura Gal <yuragal@gmail.com>
CC: pgsql-sql@postgresql.org
Subject: Re: RETURN QUERY generates error
References: <3b6c69d80803052345g31af3b74k6b8878c65197d621@mail.gmail.com>
In-Reply-To: <3b6c69d80803052345g31af3b74k6b8878c65197d621@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Yura Gal wrote:
>
>   IF _byblocks IS TRUE THEN
>   	RETURN QUERY SELECT
> regexp_split_to_table(array_to_string(_sequence, ','), E',');
>   ELSE
>   	RETURN QUERY SELECT array_to_string(_sequence, '');
>   END IF;
>   RETURN;
> END;
> $body$
> LANGUAGE 'plpgsql' IMMUTABLE CALLED ON NULL INPUT SECURITY INVOKER;
> 
> all is fine until the last IF. Both RETURN QUERY blocks generate
> error: 'syntax error at or near SELECT ...' I feel that something
> wrong with casting _sequence var but I can't figure out the exact
> point.

Can't think why it's not happy - if I create an empty table to go with 
it, it runs here. If you replace them with RETURN QUERY SELECT '' does 
that make the error go away?

Oh, and are you sure you mean IMMUTABLE? That's only true if hg18.genome 
is a static table.

-- 
   Richard Huxton
   Archonet Ltd