Re: I must be blind... - Mailing list pgsql-general

From Nigel J. Andrews
Subject Re: I must be blind...
Date
Msg-id Pine.LNX.4.21.0206142309040.4131-100000@ponder.fairway2k.co.uk
Whole thread Raw
In response to Re: I must be blind...  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Fri, 14 Jun 2002, Tom Lane wrote:

> Joe Conway <mail@joeconway.com> writes:
> > I don't think you can use PERFORM like that. Try:
>
> Actually I believe he can; after looking at the manual I realized that
> the problem is that PERFORM is syntactically a substitute for SELECT.
> In other words he needed to write
>
>     PERFORM 1 FROM orders ...
> not
>     PERFORM SELECT 1 FROM orders ...

Thanks Tom,

I didn't get that from the manual at all. I think I should go reread it.


--
Nigel J. Andrews
Director

---
Logictree Systems Limited
Computer Consultants


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: I must be blind...
Next
From: "Nigel J. Andrews"
Date:
Subject: Re: I must be blind...