Postgres Pro
Downloads
Home   >   mailing lists

Re: set value var via execute - Mailing list pgsql-general

From Peter Kroon
Subject Re: set value var via execute
Date
Msg-id CAOh+DOmM-DUb1sPTLxZ8PYVnNiaDj-oosupQ-Uwq3oxOW7XUsQ@mail.gmail.com
Whole thread Raw
In response to set value var via execute  (Peter Kroon <plakroon@gmail.com>)
List pgsql-general
Tree view
Go it:

        execute 'select id from '||v_table||' order by random() limit 1' into v_holder;


2012/11/29 Peter Kroon <plakroon@gmail.com>
 --begin this fails------------------------------------------------------------------------------------------
        v_holder = execute 'select id from '||v_table||' order by random() limit 1';
        --end this fails-------------------------------------------------------------------------------------------

pgsql-general by date:

Previous
From: icholy
Date:
Subject: libpq - PQsendQuery wait for complete result
Next
From: Jeff Janes
Date:
Subject: Re: When does CLUSTER occur?