Convert PostgreSQL Query to GORM Query

Question

How do I convert the following SQL query to GORM?

SELECT * FROM files WHERE tsv @@ plainto_tsquery('lexeme word');

Or equivalently:

SELECT * FROM files, plainto_tsquery('lexeme word') q WHERE tsv @@ q;

I can use .Exec():

err := d.Connection.DB.Exec("SELECT * FROM scenes WHERE tsv @@ plainto_tsquery(?);",text).Error
if err != nil {
    return nil, err
}

This query doesn't allow me to get an array of data and work with it. Unfortunately, I could not find a solution using the GORM documentation.

Eklavya · Accepted Answer · 2020-09-25 18:07:22Z

1

Use .Raw() for raw SQL query

db.Raw("SELECT id, name, age FROM users WHERE name = ?", 3).Scan(&result)

Official doc for about raw SQL query

answered Sep 25, 2020 at 18:07

Eklavya

18.6k4 gold badges33 silver badges62 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1