Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: I must be blind...
Date
Msg-id 9224.1024090558@sss.pgh.pa.us
Whole thread Raw
In response to Re: I must be blind...  (Joe Conway <mail@joeconway.com>)
Responses Re: I must be blind...  ("Nigel J. Andrews" <nandrews@investsystems.co.uk>)
Re: I must be blind...  ("Nigel J. Andrews" <nandrews@investsystems.co.uk>)
List pgsql-general
Tree view 
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 ...

            regards, tom lane

pgsql-general by date:

Previous
From: Bill Moran
Date:
Subject: Re: large database on postgres
Next
From: "Nigel J. Andrews"
Date:
Subject: Re: I must be blind...