> 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.
I think you can just use OR:
SELECT *
FROM table
WHERE (input = '' OR input = ?)
This is assuming that `input` is a column in your table and ? is the
user input, based on the query you provided. But are you sure that's
what you mean?
Also, if the `input` column can contain nulls you might also want:
SELECT *
FROM table
WHERE (input IS NULL OR input = '' OR input = ?)
Paul
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
