Connection.findL

Returns an array of the specified type, filtered with the given filter and params with length limited by limit

If no rows are returned by PostgreSQL, an empty array is returned. If limit is set to -1 then all filtered rows are returned.

struct Connection
T[]
findL
(
T
U...
)
(
string filter
,
int limit
,)

Examples

Connection conn; // An established connection
struct User
{
   @serial @PKey int id;
   string username;
   int posts;
};

auto users = conn.findL!User("username = $1 OR posts > $2", 5, "foo", 42);
foreach (u; users)
{
   ... // do something
}

Meta