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@xxxxxxxxxxx> wrote:
On 12/25/2015 08:26 AM, Edson F. Lidorio wrote:
via pgadmin not accept this syntax.
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
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@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
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.![]()
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
Attachment:
get_trans_min_cnt.sh
Description: Bourne shell script
-- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
