[Top]
predef::
Sql
Sql.postgres
|
Method Sql.postgres()->big_query()
- Method
big_query
-
int|object big_query(object|string q, mapping(string|int:mixed)|void bindings)
- Description
-
This is the only provided interface which allows you to query the
database. If you wish to use the simpler "query" function, you need to
use the Sql.sql generic sql-object.
It returns a postgres_result object (which conforms to the Sql.sql_result
standard interface for accessing data). I recommend using query() for
simpler queries (because it is easier to handle, but stores all the result
in memory), and big_query for queries you expect to return huge amounts
of data (it's harder to handle, but fectches results on demand).
- Note
-
This function can raise exceptions.
- See also
-
Sql.Sql, Sql.sql_result
|