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.kla...@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.kla...@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.
get_trans_min_cnt.sh
Description: Bourne shell script
-- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
