dukeofhazardz commented on issue #954:
URL: https://github.com/apache/age/issues/954#issuecomment-1570673659
Like @Chidera6 said, the query creates a GIN index on the `imdbRank`
property of the Movie nodes in the `munmud` graph. The GIN index is a versatile
index structure suitable for efficiently querying and filtering JSONB data,
which is the data type of the properties column in this case.
You can use the query `SELECT * FROM pg_indexes WHERE tablename = 'Movie';`
to retrieve information about the indexes associated with the table named
`Movie` in the 'munmud' schema.
The output should be something like this:
```
schemaname | tablename | indexname | tablespace |
indexdef
------------+-----------+-----------+------------+------------------------------------------------------------------------------------
munmud | Movie | imdb | | CREATE INDEX imdb ON
munmud."Movie" USING gin (((properties -> 'imdbRank'::text)))
(1 row)
```
You can see the `indexname` 'imdb', the `indexdef` column in the result
shows the definition of the index, including the index type (`gin` in this
case) and the expression used for indexing (((properties -> 'imdbRank'::text))).
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
