Postgres Pro
Downloads
Home   >   mailing lists

Re: Strange syntax with select - Mailing list pgsql-general

From Melvin Davidson
Subject Re: Strange syntax with select
Date
Msg-id CANu8FixWZy-DRhw3ZBQCrUrH8xWxP71pKYanFnRJ-c_2Tb_mSA@mail.gmail.com
Whole thread Raw
In response to Re: Strange syntax with select  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view
Edson,

I've attached a script that shows how to use bash to assign a variable from a SQL statement.

On Fri, Dec 25, 2015 at 12:48 PM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 12/25/2015 08:26 AM, Edson F. Lidorio wrote:





I'musing versionbelowPostgreSQL.

PostgreSQL 9.4.5 on x86_64-unknown-linux-gnu, compiled by gcc (Debian
4.9.2-10) 4.9.2, 64-bit

--
Edson

via pgadmin not accept this syntax.
You have any other way to do?

Should have added to previous post that this can be done using an anonymous function:

http://www.postgresql.org/docs/9.4/interactive/sql-do.html

The caveat being anonymous functions cannot return anything. Still something like the below:

DO
$$
DECLARE
    var_1 integer;
BEGIN
    SELECT INTO var_1 sum(cell_per) FROM cell_per;
    RAISE NOTICE 'Sum is %', var_1;
END
$$ LANGUAGE plpgsql;

NOTICE:  Sum is 193




--
Adrian Klaver
adrian.klaver@aklaver.com


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



--
Melvin Davidson
I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you.
Attachment

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Strange syntax with select
Next
From: Jim Nasby
Date:
Subject: Re: efficient math vector operations on arrays