Re: RETURN QUERY generates error - Mailing list pgsql-sql

From Tom Lane
Subject Re: RETURN QUERY generates error
Date
Msg-id 19149.1204827255@sss.pgh.pa.us
Whole thread Raw
In response to Re: RETURN QUERY generates error  (Richard Huxton <dev@archonet.com>)
Responses Re: RETURN QUERY generates error  ("Yura Gal" <yuragal@gmail.com>)
List pgsql-sql
Richard Huxton <dev@archonet.com> writes:
> Yura Gal wrote:
>> 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.

The error sounds suspiciously like what would happen if you tried to
use RETURN QUERY in a pre-8.3 version.
        regards, tom lane


pgsql-sql by date:

Previous
From: "Pavel Stehule"
Date:
Subject: Re: RETURN QUERY generates error
Next
From: tyrrill_ed@emc.com
Date:
Subject: Re: Bit string help, please