On 2/19/2015 12:39 PM, zach cruise wrote:
i want to select based on input, but if input is not provided or if input is empty, then i want to select all rows.
(metalanguage) if input is provided, then query("SELECT stuff FROM table WHERE whatever = $INPUT") else, query("SELECT stuff FROM table")
in other words, make the decision as to what query to execute OUTSIDE of sql by invoking different queries based on your application's 'input'.
-- john r pierce 37N 122W somewhere on the middle of the left coast -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
