Struct sea_query::extension::postgres::PgLTree

pub struct PgLTree;

Available on crate feature backend-postgres only.

PostgreSQL ltree extension type.

ltree stores a raber path which in this struct is represented as the tuple’s first value.

PostcreSQL Reference

The following set of SQL statements can be used to create a table with a ltree column. Here the ltree column is called path.

The path column is then populated to generate the tree.

CREATE TABLE test (path ltree);
INSERT INTO test VALUES ('Top');
INSERT INTO test VALUES ('Top.Science');
INSERT INTO test VALUES ('Top.Science.Astronomy');
INSERT INTO test VALUES ('Top.Science.Astronomy.Astrophysics');
INSERT INTO test VALUES ('Top.Science.Astronomy.Cosmology');
INSERT INTO test VALUES ('Top.Hobbies');
INSERT INTO test VALUES ('Top.Hobbies.Amateurs_Astronomy');
INSERT INTO test VALUES ('Top.Collections');
INSERT INTO test VALUES ('Top.Collections.Pictures');
INSERT INTO test VALUES ('Top.Collections.Pictures.Astronomy');
INSERT INTO test VALUES ('Top.Collections.Pictures.Astronomy.Stars');
INSERT INTO test VALUES ('Top.Collections.Pictures.Astronomy.Galaxies');
INSERT INTO test VALUES ('Top.Collections.Pictures.Astronomy.Astronauts');
CREATE INDEX path_gist_idx ON test USING GIST (path);
CREATE INDEX path_idx ON test USING BTREE (path);

The set of queries above will generate the following tree:

                       Top
                    /   |  \
             Science Hobbies Collections
               /       |              \
      Astronomy   Amateurs_Astronomy Pictures
           /  \                            |
Astrophysics  Cosmology                Astronomy
                                      /    |    \
                               Galaxies  Stars  Astronauts

Source

Trait Implementations

impl Clone for PgLTree

fn clone(&self) -> PgLTree

Returns a copy of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl Debug for PgLTree

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.

impl From<PgLTree> for String

fn from(l: PgLTree) -> Self

Converts to this type from the input type.

impl Iden for PgLTree

fn unquoted(&self, s: &mut dyn Write)

fn prepare(&self, s: &mut dyn Write, q: Quote)

fn quoted(&self, q: Quote) -> String

fn to_string(&self) -> String

impl PartialEq for PgLTree

fn eq(&self, other: &PgLTree) -> bool

This method tests for self and other values to be equal, and is used by ==.

fn ne(&self, other: &Rhs) -> bool

This method tests for !=. The default implementation is almost always sufficient, and should not be overridden without very good reason.

impl Eq for PgLTree

impl StructuralEq for PgLTree

impl StructuralPartialEq for PgLTree