@Override
	protected VectorResult queryVectorId(long id) throws SQLException {
		PreparedStatement s = selectVectorByRowIdStatement.prepareIfNeeded(() -> initConnection()
				.prepareStatement("SELECT id,count,vec FROM vectable WHERE id = ?"));
		s.setLong(1, id);
		try (ResultSet rs = s.executeQuery()) {
			if (!rs.next()) {
				throw new SQLException("Bad vectable rowid");
			}
			VectorResult rowres;
			try {
				rowres = new VectorResult();
				rowres.vectorid = rs.getLong(1);
				rowres.hitcount = rs.getInt(2);
				rowres.vec = vectorFactory.restoreVectorFromSql(rs.getString(3));
			}
			catch (final IOException e) {
				throw new SQLException(e.getMessage());
			}

			return rowres;
		}

	}
@param resultset the list of result set objects to populate
@param vec the vector containing the saveSQL query statement
@param simthresh the similarity threshold
@param sigthresh the confidence threshold
@param max the max number of results to return
@return the number of results returned
@throws SQLException if there is a problem creating or executing the query
Ghidra/Features/BSim/src/main/java/ghidra/features/bsim/query/client/PostgresFunctionDatabase.java