Lines Matching defs:rs
278 void *dbdata, PGresult **rs)
291 REQUIRE(*rs == NULL);
532 *rs = PQexec((PGconn *)dbi->dbconn, querystring );
538 for (i=0; *rs == NULL && i < 3; i++) {
553 if (PQresultStatus(*rs) == PGRES_TUPLES_OK) {
558 "%d rs ok", dlz_thread_num);
567 "%d clearing rs", dlz_thread_num);
569 PQclear(*rs); /* get rid of it */
571 *rs = NULL;
638 postgres_process_rs(dns_sdlzlookup_t *lookup, PGresult *rs)
650 rows = PQntuples(rs); /* how many rows in result set */
651 fields = PQnfields(rs); /* how many columns in result set */
656 * one column in rs, it's the data field. use
661 PQgetvalue(rs, i, 0));
667 result = dns_sdlz_putrr(lookup, PQgetvalue(rs, i, 0),
668 86400, PQgetvalue(rs, i, 1));
675 ttl = strtol(PQgetvalue(rs, i, 0), &endp, 10);
683 result = dns_sdlz_putrr(lookup, PQgetvalue(rs, i, 1),
684 ttl, PQgetvalue(rs, i, 2));
693 len += strlen(PQgetvalue(rs, i, j)) + 1;
708 PQclear(rs);
712 strcpy(tmpString, PQgetvalue(rs, i, 2));
719 strcat(tmpString, PQgetvalue(rs, i, j));
722 ttl = strtol(PQgetvalue(rs, i, 0), &endp, 10);
731 result = dns_sdlz_putrr(lookup, PQgetvalue(rs, i, 1),
739 PQclear(rs);
750 PQclear(rs);
772 PGresult *rs = NULL;
781 FINDZONE, dbdata, &rs);
784 if (rs != NULL)
785 PQclear(rs);
793 rows = PQntuples(rs);
795 PQclear(rs);
811 PGresult *rs = NULL;
829 ALLOWXFR, dbdata, &rs);
835 if (rs != NULL)
836 PQclear(rs);
844 rows = PQntuples(rs);
846 PQclear(rs);
866 PGresult *rs = NULL;
880 ALLNODES, dbdata, &rs);
886 if (rs != NULL)
887 PQclear(rs);
895 rows = PQntuples(rs); /* how many rows in result set */
896 fields = PQnfields(rs); /* how many columns in result set */
905 ttl = strtol(PQgetvalue(rs, i, 0), &endp, 10);
915 PQgetvalue(rs, i, 2),
916 PQgetvalue(rs, i, 1),
918 PQgetvalue(rs, i, 3));
926 len += strlen(PQgetvalue(rs, i, j)) + 1;
937 PQclear(rs);
941 strcpy(tmpString, PQgetvalue(rs, i, 3));
945 strcat(tmpString, PQgetvalue(rs, i, j));
949 PQgetvalue(rs, i, 2),
950 PQgetvalue(rs, i, 1),
956 PQclear(rs);
967 PQclear(rs);
987 PGresult *rs = NULL;
993 AUTHORITY, dbdata, &rs);
999 if (rs != NULL)
1000 PQclear(rs);
1012 return postgres_process_rs(lookup, rs);
1022 PGresult *rs = NULL;
1029 result = postgres_get_resultset(zone, name, NULL, LOOKUP, dbdata, &rs);
1032 if (rs != NULL)
1033 PQclear(rs);
1044 return postgres_process_rs(lookup, rs);