Re: RETURN QUERY generates error

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Richard Huxton <dev(at)archonet(dot)com>
Cc: Yura Gal <yuragal(at)gmail(dot)com>, pgsql-sql(at)postgresql(dot)org
Subject: Re: RETURN QUERY generates error
Date: 2008-03-06 18:14:15
Message-ID: 19149.1204827255@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Richard Huxton <dev(at)archonet(dot)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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message tyrrill_ed 2008-03-06 18:24:44 Re: Bit string help, please
Previous Message Pavel Stehule 2008-03-06 08:40:47 Re: RETURN QUERY generates error