class_docstr: This handler handles connection and execution of the PostgreSQL with pgvector extension statements.
class_docstr_tok: ["This","handler","handles","connection","and","execution","of","the","PostgreSQL","with","pgvector","extension","statements","."]
code: def delete(
      self, table_name: str, conditions: List[FilterCondition] = None
  ):
      filter_conditions = self._translate_conditions(conditions)
      where_clause = self._construct_where_clause(filter_conditions)
  
      with self.connection.cursor() as cur:
          # convert search embedding to string
  
          # we need to use the <-> operator to search for similar vectors,
          # so we need to convert the string to a vector and also use a threshold (e.g. 0.5)
  
          query = f"DELETE FROM {table_name} {where_clause}"
          cur.execute(query)
          self.connection.commit()
  
imports: from collections import OrderedDict
  from typing import List, Union
  import pandas
  import psycopg
  from mindsdb_sql import ASTNode, Parameter, Identifier, Update, BinaryOperation
  from pgvector.psycopg import register_vector
  from mindsdb.integrations.handlers.postgres_handler.postgres_handler import PostgresHandler
  from mindsdb.integrations.libs.const import HANDLER_CONNECTION_ARG_TYPE
  from mindsdb.integrations.libs.response import RESPONSE_TYPE
  from mindsdb.integrations.libs.response import HandlerResponse
  from mindsdb.integrations.libs.vectordatabase_handler import FilterCondition, VectorStoreHandler
  from mindsdb.utilities import log
  from mindsdb.utilities.profiler import profiler
label_desc: Use image node_id 11 for calling the PgVectorHandler obj's underlying member method code with example usage: obj.delete(table_name, conditions) without return types