pg_sql.c File Reference

Implementation of various functions that assemble SQL query strings for PostgreSQL. More...

#include "pg_sql.h"
#include "../../lib/srdb2/db_cmd.h"
#include "../../lib/srdb2/db_fld.h"
#include "../../mem/mem.h"
#include "../../dprint.h"
#include "../../ut.h"
#include <string.h>

Include dependency graph for pg_sql.c:

Go to the source code of this file.

Data Structures

• struct string_buffer

  Reallocatable string buffer. More...
  

Functions

• int build_delete_sql (str *sql_cmd, db_cmd_t *cmd)

  Builds a DELETE SQL statement.
  

• int build_insert_sql (str *sql_cmd, db_cmd_t *cmd)

  Builds an INSERT SQL statement.
  

• int build_select_sql (str *sql_cmd, db_cmd_t *cmd)

  Builds a SELECT SQL statement.
  

• int build_timestamp_format_sql (str *sql_cmd)

  Builds the SQL query used to determine the format of timestamp fields.
  

• int build_update_sql (str *sql_cmd, db_cmd_t *cmd)

  Builds an UPDATE SQL statement.
  

• static str * get_marker (unsigned int i)

  Returns a parameter marker for PostgreSQL with number i The function builds a parameter marker for use in PostgreSQL SQL queries, such as $1, $2, etc.
  

• static int sb_add (struct string_buffer *sb, str *nstr)

  Appends string to string buffer.
  

• static str * set_str (str *str, const char *s)

  Creates str string from zero terminated string without copying.
  

---

Detailed Description

Definition in file pg_sql.c.