Postgres: insertion and deletion

Question

I sense an easier way to do the code. How can I do the deletion/insertion shorter?

// to delete the old tags before inserting new tags                                                                                                                                                    
        $result = pg_query_params ( $dbconn,
                'DELETE FROM tags
                WHERE question_id = $1',
                array ( $question_id )
                );

        $result = pg_prepare ( $dbconn, "query_777",
                'INSERT INTO tags
                (tag, question_id)
                VALUES ($1, $2)'
                );

Answer 1

Not much you can do. Technically you can do it with stored procedure, and then just:

select change_question_tags( ... );

But it doesn't change much.

Answer 2

You can use some ORM/DB abstraction and then do stuff like

$tags = new TagsTable();
$tags->delete($tags->find('question_id = ?', $1));
$tags->insert(array('tag' => $1, 'question_id' => $2));

Zend_Db_Table