Lines Matching defs:rs
287 void *dbdata, PGresult **rs)
298 REQUIRE(*rs == NULL);
539 *rs = PQexec((PGconn *)dbi->dbconn, querystring );
545 for (i=0; *rs == NULL && i < 3; i++) {
560 if (PQresultStatus(*rs) == PGRES_TUPLES_OK) {
565 "%d rs ok", dlz_thread_num);
574 "%d clearing rs", dlz_thread_num);
576 PQclear(*rs); /* get rid of it */
644 postgres_process_rs(dns_sdlzlookup_t *lookup, PGresult *rs)
656 rows = PQntuples(rs); /* how many rows in result set */
657 fields = PQnfields(rs); /* how many columns in result set */
662 * one column in rs, it's the data field. use
667 PQgetvalue(rs, i, 0));
673 result = dns_sdlz_putrr(lookup, PQgetvalue(rs, i, 0),
674 86400, PQgetvalue(rs, i, 1));
681 ttl = strtol(PQgetvalue(rs, i, 0), &endp, 10);
689 result = dns_sdlz_putrr(lookup, PQgetvalue(rs, i, 1),
690 ttl, PQgetvalue(rs, i, 2));
699 len += strlen(PQgetvalue(rs, i, j)) + 1;
714 PQclear(rs);
718 strcpy(tmpString, PQgetvalue(rs, i, 2));
725 strcat(tmpString, PQgetvalue(rs, i, j));
728 ttl = strtol(PQgetvalue(rs, i, 0), &endp, 10);
737 result = dns_sdlz_putrr(lookup, PQgetvalue(rs, i, 1),
745 PQclear(rs);
756 PQclear(rs);
776 PGresult *rs = NULL;
782 FINDZONE, dbdata, &rs);
785 if (rs != NULL)
786 PQclear(rs);
794 rows = PQntuples(rs);
796 PQclear(rs);
812 PGresult *rs = NULL;
830 ALLOWXFR, dbdata, &rs);
836 if (rs != NULL)
837 PQclear(rs);
845 rows = PQntuples(rs);
847 PQclear(rs);
867 PGresult *rs = NULL;
881 ALLNODES, dbdata, &rs);
887 if (rs != NULL)
888 PQclear(rs);
896 rows = PQntuples(rs); /* how many rows in result set */
897 fields = PQnfields(rs); /* how many columns in result set */
906 ttl = strtol(PQgetvalue(rs, i, 0), &endp, 10);
916 PQgetvalue(rs, i, 2),
917 PQgetvalue(rs, i, 1),
919 PQgetvalue(rs, i, 3));
927 len += strlen(PQgetvalue(rs, i, j)) + 1;
938 PQclear(rs);
942 strcpy(tmpString, PQgetvalue(rs, i, 3));
946 strcat(tmpString, PQgetvalue(rs, i, j));
950 PQgetvalue(rs, i, 2),
951 PQgetvalue(rs, i, 1),
957 PQclear(rs);
968 PQclear(rs);
988 PGresult *rs = NULL;
994 AUTHORITY, dbdata, &rs);
1000 if (rs != NULL)
1001 PQclear(rs);
1013 return postgres_process_rs(lookup, rs);
1022 PGresult *rs = NULL;
1027 result = postgres_get_resultset(zone, name, NULL, LOOKUP, dbdata, &rs);
1030 if (rs != NULL)
1031 PQclear(rs);
1042 return postgres_process_rs(lookup, rs);