Function Database_Static_postgresql->query
Definitions
sources/database/postgresql.php
- This function is a raw query executor.This should rarely ever be used; other functions like query_select are available. Additionally, for complex queries, it is still better to use query_parameterised as it handles escaping.
- Visibility: public
- Is abstract?: No
- Is static?: No
- Is final?: No
- Return: N/A
Parameters
| Name | Type | Default | Set | Range | Description |
|---|---|---|---|---|---|
| $query | string | required parameter | N/A | N/A | The complete SQL query |
| $connection | mixed | required parameter | N/A | N/A | The DB connection |
| $max | ?integer | Null | N/A | N/A | The maximum number of rows to affect (null: no limit) |
| $start | integer | 0 | N/A | N/A | The start row to affect |
| $fail_ok | boolean | False | N/A | N/A | Whether to output an error on failure |
| $get_insert_id | boolean | False | N/A | N/A | Whether to get the autoincrement ID created for an insert query |
| $save_as_volatile | boolean | False | N/A | N/A | Whether we are saving as a 'volatile' file extension |
Return
- The results (null: no results), or the insert ID
- Type: ?mixed
- Set: N/A
- Range: N/A