1 /*
2 * PostRR - src/utils/pg_spi.c
3 * Copyright (C) 2012 Sebastian 'tokkee' Harl <sh@tokkee.org>
4 * All rights reserved.
5 *
6 * Redistribution and use in source and binary forms, with or without
7 * modification, are permitted provided that the following conditions
8 * are met:
9 * 1. Redistributions of source code must retain the above copyright
10 * notice, this list of conditions and the following disclaimer.
11 * 2. Redistributions in binary form must reproduce the above copyright
12 * notice, this list of conditions and the following disclaimer in the
13 * documentation and/or other materials provided with the distribution.
14 *
15 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
16 * ``AS IS'' AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED
17 * TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR
18 * PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDERS OR
19 * CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL,
20 * EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO,
21 * PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS;
22 * OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY,
23 * WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR
24 * OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF
25 * ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
26 */
28 /*
29 * Helpers for using the PostgreSQL Server Programming Interface (SPI).
30 */
32 enum {
33 PG_SPI_OK = 0,
34 PG_SPI_ERROR_EXEC_QUERY,
35 PG_SPI_ERROR_NO_VALUES,
36 };
38 #define PG_SPI_GET_STATUS(rc) ((rc) & 0xF)
39 #define PG_SPI_GET_SPI_STATUS(rc) ((rc) >> 4)
40 #define PG_SPI_MAKE_RC(status, spi_status) \
41 (((spi_status) << 4) | ((PG_SPI_ ## status) & 0xF))
43 int
44 pg_spi_get_int(const char *query, int num_vals, ...);
46 int
47 pg_spi_ereport(int elevel, const char *context, int rc);
49 /* vim: set tw=78 sw=4 ts=4 noexpandtab : */