hello, is there any documentations on setting up L...
# helpe
eri
11/20/2021, 3:01 AMhello, is there any documentations on setting up LTREE with supabase?
t
tourdownunder
11/20/2021, 3:51 AMHi. Firstly most of us are on all the channels so no need to cross post.
tourdownunder
11/20/2021, 3:53 AMI assume you are talking about the built in postgres module
e
eri
11/20/2021, 3:53 AMSorry for that! I am new to Discord as well as supabase.
eri
11/20/2021, 3:54 AMI am trying to create nodes table and I thought I'll use LTREE extension for better performance.
eri
11/20/2021, 3:56 AMAfter doing some research, if I add a column "node_path" as ltree data type, I can then do a query for node_path 001.001.002*
eri
11/20/2021, 3:57 AMcan you help me with this or suggest an alternative way?
eri
11/20/2021, 4:01 AMand yes, I am talking about the built in postgres module/extension
t
tourdownunder
11/20/2021, 4:01 AMyou will be able to create a plpgsql function and achieve what you need.
tourdownunder
11/20/2021, 4:03 AMI should call them rpc functions. See https://supabase.com/docs/guides/database/functions
e
eri
11/20/2021, 4:05 AMperfect, thank you. I will take a look at this