Pike v8.0 release 702

Method Sql.Sql()->big_typed_query()


Method big_typed_query

int|object big_typed_query(object|string q, mixed ... extraargs)

Description

Sends an SQL query synchronously to the underlying SQL-server and returns the results in typed mode.

For the arguments, please see the query() function.

The result is returned as an Sql.sql_result object in typed mode. This allows for having some more info about the result as well as processing the result in a streaming fashion, although the result itself wasn't obtained streamingly from the server. Returns 0 if the query didn't return any result (e.g. INSERT or similar).

Note

Typed mode support varies per database and per datatype. SQL datatypes which the current database cannot return as a native Pike type, will be returned as (untyped) strings.

Note

Despite the name, this function is not only useful for "big" queries. It typically has less overhead than typed_query also for ones that return only a few rows.

See also

query, typed_query, big_query, streaming_query