Schema: `public`

Auto-generated by npm run gendocs. Do not edit by hand — changes will be overwritten. To update, run npm run gendocs against a database with the latest migrations applied.

Counts: 24 tables · 8 views · 0 materialized views · 358 functions · 27 policies

Tables (24)

account_account

RLS enabled.

Column	Type	Null	Default	Comment
`account_id`	`uuid`	no
`relation`	`account_relation_type`	no
`other_account_id`	`uuid`	no
`include_share`	`smallint`	yes	`'100'::smallint`
`from_date`	`date`	yes
`to_date`	`date`	yes
`id`	`integer`	no		Needed for genericCrudActions

Primary key: PRIMARY KEY (account_id, relation, other_account_id)

Foreign keys:

account_account_account_id_fkey: FOREIGN KEY (account_id) REFERENCES basejump.accounts(id) ON DELETE CASCADE
account_account_other_account_id_fkey: FOREIGN KEY (other_account_id) REFERENCES basejump.accounts(id) ON DELETE CASCADE

Checks:

valid_relationship: CHECK (account_id <> other_account_id)

Policies:

Owners/Owneds and Customers/Suppliers can access and modify — ALL, PERMISSIVE, roles: authenticated
- USING: ((account_id IN ( SELECT basejump.get_accounts_with_role() AS get_accounts_with_role)) OR (other_account_id IN ( SELECT basejump.get_accounts_with_role() AS get_accounts_with_role)))
- WITH CHECK: ((account_id IN ( SELECT basejump.get_accounts_with_role() AS get_accounts_with_role)) OR (other_account_id IN ( SELECT basejump.get_accounts_with_role() AS get_accounts_with_role)))

account_category

RLS enabled.

Column	Type	Null	Default
`account_id`	`uuid`	no
`category_id`	`integer`	no
`can_input`	`boolean`	yes	`true`
`can_report`	`boolean`	yes	`true`
`status`	`project_status`	no	`'not-started'::project_status`

Primary key: PRIMARY KEY (account_id, category_id)

Foreign keys:

account_category_account_id_fkey: FOREIGN KEY (account_id) REFERENCES basejump.accounts(id) ON DELETE CASCADE
account_category_category_id_fkey: FOREIGN KEY (category_id) REFERENCES category(id) ON DELETE CASCADE

Policies:

Owners of account or parent account of account can crud — ALL, PERMISSIVE, roles: authenticated
- USING: (EXISTS ( SELECT 1 FROM get_parent_accounts(get_account_slug(account_category.account_id)) parent_account(id, parent_account_id, name, slug) WHERE basejump.has_role_on_account(parent_account.id, 'owner'::basejump.account_role)))
- WITH CHECK: (EXISTS ( SELECT 1 FROM get_parent_accounts(get_account_slug(account_category.account_id)) parent_account(id, parent_account_id, name, slug) WHERE basejump.has_role_on_account(parent_account.id, 'owner'::basejump.account_role)))

account_category_user

RLS enabled.

Column	Type	Null	Default
`account_id`	`uuid`	no
`category_id`	`integer`	no
`user_id`	`uuid`	no
`account_role`	`account_role`	no	`'member'::account_role`
`created_at`	`timestamp with time zone`	yes	`now()`

Primary key: PRIMARY KEY (account_id, category_id, user_id)

Foreign keys:

account_category_user_account_id_fkey: FOREIGN KEY (account_id) REFERENCES basejump.accounts(id) ON DELETE CASCADE
account_category_user_category_id_fkey: FOREIGN KEY (category_id) REFERENCES category(id) ON DELETE CASCADE
account_category_user_user_id_fkey: FOREIGN KEY (user_id) REFERENCES auth.users(id) ON DELETE CASCADE

Policies:

Owners of account or parent account of account can crud — ALL, PERMISSIVE, roles: authenticated
- USING: (EXISTS ( SELECT 1 FROM get_parent_accounts(get_account_slug(account_category_user.account_id)) parent_account(id, parent_account_id, name, slug) WHERE basejump.has_role_on_account(parent_account.id, 'owner'::basejump.account_role)))
- WITH CHECK: (EXISTS ( SELECT 1 FROM get_parent_accounts(get_account_slug(account_category_user.account_id)) parent_account(id, parent_account_id, name, slug) WHERE basejump.has_role_on_account(parent_account.id, 'owner'::basejump.account_role)))

accounting_category

RLS enabled.

Column	Type	Null	Default
`id`	`integer`	no
`account_id`	`uuid`	yes
`parent_accounting_category_id`	`integer`	yes
`name`	`text`	yes
`emission_factor_id`	`integer`	yes
`category_id`	`integer`	yes
`nace_category_id`	`integer`	yes
`external_accounting_category_id`	`character varying(10)`	yes
`include_emissions`	`smallint`	yes	`'100'::smallint`

Primary key: PRIMARY KEY (id)

Foreign keys:

accounting_category_category_id_fkey: FOREIGN KEY (category_id) REFERENCES category(id) ON DELETE SET NULL
accounting_category_emission_factor_id_fkey: FOREIGN KEY (emission_factor_id) REFERENCES emission_factor(id) ON DELETE SET NULL
accounting_category_nace_category_id_fkey: FOREIGN KEY (nace_category_id) REFERENCES nace_category(id) ON DELETE SET NULL
accounting_category_parent_accounting_category_id_fkey: FOREIGN KEY (parent_accounting_category_id) REFERENCES accounting_category(id) ON DELETE CASCADE

Policies:

Account members can access and modify — ALL, PERMISSIVE, roles: authenticated
- USING: (account_id IN ( SELECT basejump.get_accounts_with_role() AS get_accounts_with_role))
- WITH CHECK: (account_id IN ( SELECT basejump.get_accounts_with_role() AS get_accounts_with_role))

activity

RLS enabled.

Column	Type	Null	Default	Comment
`id`	`bigint`	no
`created_at`	`timestamp with time zone`	no	`now()`
`metadata`	`jsonb`	yes
`day`	`smallint`	yes
`month`	`smallint`	yes
`year`	`smallint`	no
`account_id`	`uuid`	yes
`category_id`	`integer`	yes
`supplier_account_id`	`uuid`	yes		Possibly have a duplicate activity entry which corresponds to the same activity in the supplier’s records.
`duration`	`duration_months`	yes		For how many months does the emissions of this activity apply?
`customer_account_id`	`uuid`	yes
`country_id`	`integer`	yes

Primary key: PRIMARY KEY (id)

Foreign keys:

accounts_account_id_fkey: FOREIGN KEY (account_id) REFERENCES basejump.accounts(id) ON DELETE SET NULL
accounts_supplier_account_id_fkey: FOREIGN KEY (supplier_account_id) REFERENCES basejump.accounts(id) ON DELETE SET NULL
activity_category_id_fkey: FOREIGN KEY (category_id) REFERENCES category(id) ON DELETE CASCADE NOT VALID
activity_country_id_fkey: FOREIGN KEY (country_id) REFERENCES country(id) ON DELETE SET NULL
activity_customer_account_id_fkey: FOREIGN KEY (customer_account_id) REFERENCES basejump.accounts(id) ON DELETE SET NULL

Checks:

check_year_valid: CHECK (year >= 1900)
row_input_day_check: CHECK (day >= 1 AND day <= 31)
row_input_month_check: CHECK (month >= 1 AND month <= 12)

Policies:

Account members can access and modify — ALL, PERMISSIVE, roles: authenticated
- USING: (account_id IN ( SELECT basejump.get_accounts_with_role() AS get_accounts_with_role))
- WITH CHECK: (account_id IN ( SELECT basejump.get_accounts_with_role() AS get_accounts_with_role))

category_submission

RLS enabled.

Column	Type	Null
`id`	`integer`	no
`category_id`	`integer`	no
`account_id`	`uuid`	no
`year`	`smallint`	no
`comments`	`text`	yes
`content`	`jsonb`	yes
`requirements_status`	`jsonb`	yes

Primary key: PRIMARY KEY (id)

Unique:

text_content_unique_key: UNIQUE (category_id, account_id, year)

Foreign keys:

text_content_account_id_fkey: FOREIGN KEY (account_id) REFERENCES basejump.accounts(id) ON DELETE CASCADE
text_content_category_id_fkey: FOREIGN KEY (category_id) REFERENCES category(id) ON DELETE CASCADE

Policies:

Account members can access and modify — ALL, PERMISSIVE, roles: authenticated
- USING: (account_id IN ( SELECT basejump.get_accounts_with_role() AS get_accounts_with_role))
- WITH CHECK: (account_id IN ( SELECT basejump.get_accounts_with_role() AS get_accounts_with_role))

country

RLS enabled.

Column	Type	Null
`id`	`integer`	no
`name`	`text`	yes
`code`	`character varying(2)`	yes

Primary key: PRIMARY KEY (id)

Unique:

country_code_key: UNIQUE (code)

Policies:

All logged in users can select — SELECT, PERMISSIVE, roles: authenticated
- USING: true

currency_rate

RLS enabled.

Column	Type	Null
`currency_code`	`character(3)`	no
`year`	`integer`	no
`rate_in_eur`	`numeric(10,6)`	no

Primary key: PRIMARY KEY (year, currency_code)

Checks:

currency_rate_rate_in_eur_check: CHECK (rate_in_eur > 0::numeric)

Policies:

All logged in users can select — SELECT, PERMISSIVE, roles: authenticated
- USING: true

destination

RLS enabled.

Column	Type	Null
`id`	`integer`	no
`name`	`character varying(128)`	yes
`coordinates`	`gis.geometry(Point,4326)`	yes
`country_code`	`character varying(2)`	yes

Primary key: PRIMARY KEY (id)

Unique:

destination_name_key: UNIQUE (name)

Policies:

All logged in users can select — SELECT, PERMISSIVE, roles: authenticated
- USING: true

emission

RLS enabled.

Column	Type	Null
`id`	`bigint`	no
`activity_id`	`bigint`	no
`units_amount`	`double precision`	no
`emission_factor_id`	`bigint`	no

Primary key: PRIMARY KEY (id)

Foreign keys:

emission_activity_id_fkey: FOREIGN KEY (activity_id) REFERENCES activity(id) ON DELETE CASCADE NOT VALID
emission_emission_factor_id_fkey: FOREIGN KEY (emission_factor_id) REFERENCES emission_factor(id) ON DELETE CASCADE NOT VALID

Policies:

Account members can access and modify — ALL, PERMISSIVE, roles: authenticated
- USING: (activity_id IN ( SELECT activity.id FROM activity WHERE (activity.account_id IN ( SELECT basejump.get_accounts_with_role() AS get_accounts_with_role))))
- WITH CHECK: (activity_id IN ( SELECT activity.id FROM activity WHERE (activity.account_id IN ( SELECT basejump.get_accounts_with_role() AS get_accounts_with_role))))

emission_factor

RLS enabled.

Column	Type	Null	Default
`id`	`bigint`	no
`created_at`	`timestamp with time zone`	no	`now()`
`co2_per_unit`	`double precision`	no
`unit`	`character varying`	no
`name`	`character varying`	no
`scope_1_factor`	`double precision`	no	`'0'::double precision`
`scope_2_factor`	`double precision`	no	`'0'::double precision`
`account_id`	`uuid`	yes
`year`	`smallint`	no
`country_id`	`integer`	yes
`nace_category_id`	`integer`	yes
`category_id`	`bigint`	yes

Primary key: PRIMARY KEY (id)

Foreign keys:

emission_factor_category_id_fkey: FOREIGN KEY (category_id) REFERENCES category(id)
emission_factor_country_id_fkey: FOREIGN KEY (country_id) REFERENCES country(id) ON DELETE SET NULL
emission_factor_nace_category_id_fkey: FOREIGN KEY (nace_category_id) REFERENCES nace_category(id) ON DELETE SET NULL

Policies:

Account members can access and modify — ALL, PERMISSIVE, roles: authenticated
- USING: (account_id IN ( SELECT basejump.get_accounts_with_role() AS get_accounts_with_role))
- WITH CHECK: (account_id IN ( SELECT basejump.get_accounts_with_role() AS get_accounts_with_role))
All logged in users can select emission_factors with no account — SELECT, PERMISSIVE, roles: authenticated
- USING: (account_id IS NULL)

error_code

RLS enabled.

Column	Type	Null	Default
`id`	`integer`	no
`created_at`	`timestamp with time zone`	no	`now()`
`code`	`text`	no
`description`	`text`	no

Primary key: PRIMARY KEY (id)

Unique:

error_code_code_key: UNIQUE (code)

Policies:

All users can select — SELECT, PERMISSIVE, roles: public
- USING: true

imported_addresses_list

RLS enabled.

Column	Type	Null	Default
`id`	`uuid`	no	`uuid_generate_v4()`
`date`	`text`	no	`to_char(now(), 'YYYY-MM-DD'::text)`
`created_at`	`timestamp with time zone`	yes	`now()`
`total_row_number`	`integer`	no
`chunk_row_number`	`integer`	no
`address_status`	`process_status`	no	`'not-started'::process_status`
`address_row_index`	`integer`	no	`0`
`extra_data_status`	`process_status`	no	`'not-started'::process_status`
`extra_data_row_index`	`integer`	no	`0`
`source_file`	`text`	no
`data`	`jsonb`	no
`source`	`text`	yes
`comment`	`text`	yes

Primary key: PRIMARY KEY (id)

Policies:

All logged in users can access and modify — ALL, PERMISSIVE, roles: authenticated
- USING: true

imported_addresses_missing_letters

RLS enabled.

Column	Type	Null	Default
`id`	`uuid`	no	`uuid_generate_v4()`
`created_at`	`timestamp with time zone`	yes	`now()`
`company_id`	`text`	yes
`letter`	`text`	yes
`file_name`	`text`	yes

Primary key: PRIMARY KEY (id)

Unique:

imported_addresses_missing_lett_company_id_letter_file_name_key: UNIQUE (company_id, letter, file_name)

imported_list

RLS enabled.

Column	Type	Null	Default
`id`	`integer`	no
`created_at`	`timestamp with time zone`	yes	`now()`
`file_id`	`uuid`	yes
`row_number`	`integer`	no
`status`	`process_status`	no	`'not-started'::process_status`
`data`	`jsonb`	no
`comment`	`text`	yes
`file_name`	`text`	no	`'(unknown)'::text`
`sheet_name`	`text`	yes

Primary key: PRIMARY KEY (id)

Foreign keys:

imported_list_file_id_fkey: FOREIGN KEY (file_id) REFERENCES storage.objects(id) ON DELETE CASCADE

Policies:

All logged in users can access and modify — ALL, PERMISSIVE, roles: authenticated
- USING: true

imported_routes_list

RLS enabled.

Column	Type	Null	Default
`id`	`uuid`	no	`uuid_generate_v4()`
`date`	`text`	no	`to_char(now(), 'YYYY-MM-DD'::text)`
`created_at`	`timestamp with time zone`	yes	`now()`
`row_number`	`integer`	no
`status`	`process_status`	no	`'not-started'::process_status`
`data`	`jsonb`	no
`source`	`text`	yes
`comment`	`text`	yes

Primary key: PRIMARY KEY (id)

Policies:

All logged in users can access and modify — ALL, PERMISSIVE, roles: authenticated
- USING: true

imported_sources

RLS enabled.

Column	Type	Null	Default
`id`	`uuid`	no	`uuid_generate_v4()`
`added_at`	`timestamp with time zone`	yes	`now()`
`file_name`	`text`	yes
`key`	`text`	yes
`type`	`text`	yes
`source`	`text`	yes
`is_handled`	`boolean`	yes

Primary key: PRIMARY KEY (id)

Unique:

imported_sources_file_name_key_key: UNIQUE (file_name, key)

Policies:

All logged in users can access and modify — ALL, PERMISSIVE, roles: authenticated
- USING: true

nace_category

RLS enabled.

Column	Type	Null
`id`	`integer`	no
`name`	`text`	yes
`parent_nace_category_id`	`integer`	yes
`category_id`	`integer`	yes

Primary key: PRIMARY KEY (id)

Foreign keys:

nace_category_category_id_fkey: FOREIGN KEY (category_id) REFERENCES category(id) ON DELETE SET NULL
nace_category_parent_nace_category_id_fkey: FOREIGN KEY (parent_nace_category_id) REFERENCES nace_category(id) ON DELETE CASCADE

Policies:

All logged in users can select — SELECT, PERMISSIVE, roles: authenticated
- USING: true

order

RLS enabled.

Column	Type	Null	Default
`id`	`bigint`	no
`delivery_date`	`timestamp with time zone`	no
`product`	`character varying`	yes
`customer`	`character varying`	yes
`customer_no`	`character varying`	yes
`tracking_id`	`character varying`	yes
`weight`	`real`	yes
`volume`	`real`	yes
`transporter`	`character varying`	yes
`metadata`	`jsonb`	yes
`created_at`	`timestamp with time zone`	yes	`now()`
`customer_account_id`	`uuid`	yes
`transporter_account_id`	`uuid`	yes
`from_zipcode_id`	`integer`	yes
`to_zipcode_id`	`integer`	yes
`to_district_node_id`	`integer`	yes
`from_zipcode`	`text`	yes
`to_zipcode`	`text`	yes
`to_street`	`text`	yes
`to_door`	`text`	yes
`to_city`	`text`	yes
`error_codes`	`integer[]`	yes
`to_address_id`	`integer`	yes

Primary key: PRIMARY KEY (id)

Unique:

order_tracking_id_key: UNIQUE (tracking_id)

Foreign keys:

order_customer_account_id_fkey: FOREIGN KEY (customer_account_id) REFERENCES basejump.accounts(id) ON DELETE SET NULL
order_from_zipcode_id_fkey: FOREIGN KEY (from_zipcode_id) REFERENCES parcel.address_zipcode(id) ON DELETE SET NULL
order_to_address_id_fkey: FOREIGN KEY (to_address_id) REFERENCES parcel.address_v2(id) ON DELETE SET NULL
order_to_district_node_id_fkey: FOREIGN KEY (to_district_node_id) REFERENCES parcel.transporter_node_v2(id) ON DELETE SET NULL
order_to_zipcode_id_fkey: FOREIGN KEY (to_zipcode_id) REFERENCES parcel.address_zipcode(id) ON DELETE SET NULL
order_transporter_account_id_fkey: FOREIGN KEY (transporter_account_id) REFERENCES basejump.accounts(id) ON DELETE SET NULL

Policies:

Customer accounts and transporter accounts can read orders — SELECT, PERMISSIVE, roles: authenticated
- USING: ((customer_account_id IN ( SELECT basejump.get_accounts_with_role() AS get_accounts_with_role)) OR (transporter_account_id IN ( SELECT basejump.get_accounts_with_role() AS get_accounts_with_role)) OR (transporter_account_id IN ( SELECT account_account.other_account_id FROM account_account WHERE (account_account.account_id IN ( SELECT basejump.get_accounts_with_role() AS get_accounts_with_role)))))

report

RLS enabled.

Column	Type	Null	Default
`id`	`bigint`	no
`created_at`	`timestamp with time zone`	no	`now()`
`period`	`smallint`	no
`name`	`character varying`	no
`account_id`	`uuid`	no
`user_id`	`uuid`	no	`auth.uid()`
`slug`	`character varying(100)`	yes

Primary key: PRIMARY KEY (id)

Policies:

Account members can insert — INSERT, PERMISSIVE, roles: authenticated
- WITH CHECK: (account_id IN ( SELECT basejump.get_accounts_with_role() AS get_accounts_with_role))
Account members can select — SELECT, PERMISSIVE, roles: authenticated
- USING: (account_id IN ( SELECT basejump.get_accounts_with_role() AS get_accounts_with_role))

report_status

RLS enabled.

Column	Type	Null	Default
`id`	`bigint`	no
`created_at`	`timestamp with time zone`	no	`now()`
`name`	`character varying`	no
`account_id`	`uuid`	yes
`user_id`	`uuid`	yes	`auth.uid()`

Primary key: PRIMARY KEY (id)

Policies:

Account members can select — SELECT, PERMISSIVE, roles: authenticated
- USING: (account_id IN ( SELECT basejump.get_accounts_with_role() AS get_accounts_with_role))

route_data

RLS enabled.

Column	Type	Null	Default
`id`	`uuid`	no	`uuid_generate_v4()`
`route_id`	`text`	yes
`raw_weekdays`	`text`	yes
`weekdays`	`text`	yes
`data`	`jsonb`	no
`source`	`text`	yes

Primary key: PRIMARY KEY (id)

Unique:

route_data_route_id_raw_weekdays_key: UNIQUE (route_id, raw_weekdays)

Policies:

All logged in users can access and modify — ALL, PERMISSIVE, roles: authenticated
- USING: true

settings

RLS enabled.

Column	Type	Null	Default	Comment
`key`	`text`	no
`value`	`text`	yes

Primary key: PRIMARY KEY (key)

Policies:

Allow read access to settings — SELECT, PERMISSIVE, roles: authenticated, service_role
- USING: true
Allow service role to manage settings — ALL, PERMISSIVE, roles: service_role
- USING: true
- WITH CHECK: true

Views (8)

view_accounting_categories

view

Column	Type
`id`	`integer`
`account_id`	`uuid`
`account_name`	`text`
`name`	`text`
`parent_accounting_category_id`	`integer`
`parent_accounting_category_name`	`text`
`emission_factor_id`	`integer`
`emission_factor_name`	`character varying`
`category_id`	`integer`
`category_name`	`character varying`
`nace_category_id`	`integer`
`nace_category_name`	`text`
`external_accounting_category_id`	`character varying(10)`

SELECT ac.id,
    ac.account_id,
    acc.name AS account_name,
    ac.name,
    ac.parent_accounting_category_id,
    acp.name AS parent_accounting_category_name,
    ac.emission_factor_id,
    ef.name AS emission_factor_name,
    ac.category_id,
    c.name AS category_name,
    ac.nace_category_id,
    nc.name AS nace_category_name,
    ac.external_accounting_category_id
   FROM accounting_category ac
     LEFT JOIN basejump.accounts acc ON ac.account_id = acc.id
     LEFT JOIN accounting_category acp ON ac.parent_accounting_category_id = acp.id
     LEFT JOIN emission_factor ef ON ac.emission_factor_id = ef.id
     LEFT JOIN category c ON ac.category_id = c.id
     LEFT JOIN nace_category nc ON ac.nace_category_id = nc.id
  ORDER BY ac.name;

view_activities_with_emissions

view

Column	Type
`id`	`bigint`
`account_id`	`uuid`
`account_slug`	`text`
`category_id`	`bigint`
`category_slug`	`character varying`
`year`	`smallint`
`month`	`smallint`
`duration`	`duration_months`
`country_id`	`integer`
`country_name`	`text`
`supplier_account_id`	`uuid`
`supplier_account_name`	`text`
`customer_account_id`	`uuid`
`customer_account_name`	`text`
`metadata`	`jsonb`
`co2`	`numeric`
`emission_id`	`bigint`
`units_amount`	`double precision`
`emission_factor_id`	`bigint`
`emission_factor_name`	`character varying`
`co2_per_unit`	`numeric`
`unit`	`character varying`
`emission_factor_category_id`	`bigint`
`emission_factor_category_name`	`character varying`

SELECT a.id,
    a.account_id,
    acc.slug AS account_slug,
    c.id AS category_id,
    c.slug AS category_slug,
    a.year,
    a.month,
    a.duration,
    country.id AS country_id,
    country.name AS country_name,
    a.supplier_account_id,
    supplier.name AS supplier_account_name,
    a.customer_account_id,
    customer.name AS customer_account_name,
    a.metadata,
    round(e.units_amount::numeric * ef.co2_per_unit::numeric, 2) AS co2,
    e.id AS emission_id,
    e.units_amount,
    ef.id AS emission_factor_id,
    ef.name AS emission_factor_name,
    round(ef.co2_per_unit::numeric, 3) AS co2_per_unit,
    ef.unit,
    ef_c.id AS emission_factor_category_id,
    ef_c.name AS emission_factor_category_name
   FROM activity a
     LEFT JOIN emission e ON e.activity_id = a.id
     LEFT JOIN emission_factor ef ON ef.id = e.emission_factor_id
     LEFT JOIN category c ON c.id = a.category_id
     LEFT JOIN country ON country.id = a.country_id
     LEFT JOIN basejump.accounts acc ON acc.id = a.account_id
     LEFT JOIN basejump.accounts supplier ON supplier.id = a.supplier_account_id
     LEFT JOIN basejump.accounts customer ON customer.id = a.customer_account_id
     LEFT JOIN category ef_c ON ef_c.id = ef.category_id;

view_categories_overview

view

Column	Type
`all_category_slugs`	`character varying[]`
`account_id`	`uuid`
`account_slug`	`text`
`child_category_position`	`integer`
`child_category_id`	`bigint`
`child_category_slug`	`character varying`
`child_category_reference`	`character varying`
`child_category_name`	`character varying`
`child_category_can_input`	`boolean`
`child_category_status`	`project_status`
`child_category_progress`	`numeric`
`child_category_users`	`json`
`child_category_accounts`	`json`
`parent_category_position`	`integer`
`parent_category_id`	`bigint`
`parent_category_slug`	`character varying`
`parent_category_reference`	`character varying`
`parent_category_name`	`character varying`
`parent_category_can_input`	`boolean`
`parent_category_status`	`project_status`
`parent_category_progress`	`numeric`

WITH RECURSIVE category_hierarchy AS (
         SELECT ac.account_id,
            ac.category_id::bigint AS category_id,
            ac.can_input
           FROM account_category ac
        UNION ALL
         SELECT ch.account_id,
            c.id AS category_id,
            COALESCE(ch.can_input, ac.can_input) AS can_input
           FROM category c
             JOIN category_hierarchy ch ON c.parent_category_id = ch.category_id
             LEFT JOIN account_category ac ON ac.account_id = ch.account_id AND ac.category_id = c.id
        ), child_category_account AS (
         SELECT ac.category_id,
            owner_acc.id AS owner_account_id,
            json_build_object('id', sub_acc.id, 'name', sub_acc.name, 'status', ac.status) AS account_info
           FROM basejump.accounts owner_acc
             LEFT JOIN account_account aa ON owner_acc.id = aa.account_id AND aa.relation = 'owner-of'::account_relation_type
             LEFT JOIN basejump.accounts sub_acc ON aa.other_account_id = sub_acc.id
             LEFT JOIN account_category ac ON sub_acc.id = ac.account_id
          GROUP BY ac.category_id, ac.status, owner_acc.id, sub_acc.id
        ), child_progress AS (
         SELECT category_hierarchy_1.account_id,
            category_hierarchy_1.category_id,
            ( SELECT avg(
                        CASE
                            WHEN (elem.value ->> 'status'::text) = 'in-progress'::text THEN 0.5
                            WHEN (elem.value ->> 'status'::text) = ANY (ARRAY['in-review'::text, 'in-parent-review'::text]) THEN 0.75
                            WHEN (elem.value ->> 'status'::text) = 'completed'::text THEN 1.0
                            ELSE 0::numeric
                        END) AS avg
                   FROM json_array_elements((COALESCE(json_agg(child_category_account_1.account_info) FILTER (WHERE child_category_account_1.account_info IS NOT NULL), '[]'::json)::jsonb ||
                        CASE
                            WHEN child_account_category_1.status IS NOT NULL THEN json_build_array(json_build_object('status', child_account_category_1.status))::jsonb
                            ELSE '[]'::jsonb
                        END)::json) elem(value)) AS child_category_progress
           FROM category_hierarchy category_hierarchy_1
             LEFT JOIN account_category child_account_category_1 ON child_account_category_1.category_id = category_hierarchy_1.category_id AND child_account_category_1.account_id = category_hierarchy_1.account_id
             LEFT JOIN child_category_account child_category_account_1 ON child_category_account_1.owner_account_id = category_hierarchy_1.account_id AND child_category_account_1.category_id = category_hierarchy_1.category_id
          GROUP BY category_hierarchy_1.account_id, category_hierarchy_1.category_id, child_account_category_1.status
        ), parent_progress AS (
         SELECT category_hierarchy_1.account_id,
            parent_category_1.slug AS parent_category_slug,
            avg(COALESCE(child_progress_1.child_category_progress, 0::numeric)) AS parent_category_progress
           FROM category_hierarchy category_hierarchy_1
             LEFT JOIN child_progress child_progress_1 ON child_progress_1.account_id = category_hierarchy_1.account_id AND child_progress_1.category_id = category_hierarchy_1.category_id
             LEFT JOIN category child_category_1 ON child_category_1.id = category_hierarchy_1.category_id
             LEFT JOIN category parent_category_1 ON parent_category_1.id = child_category_1.parent_category_id
          GROUP BY category_hierarchy_1.account_id, parent_category_1.slug
        ), child_category_user AS (
         SELECT account_category_user.account_id,
            account_category_user.category_id,
            json_build_object('id', users.id, 'name', accounts.name, 'email', users.email, 'role', account_category_user.account_role) AS user_info
           FROM account_category_user
             LEFT JOIN auth.users ON account_category_user.user_id = users.id
             LEFT JOIN basejump.accounts ON users.id = accounts.id AND accounts.personal_account = true
          GROUP BY account_category_user.account_id, account_category_user.category_id, users.id, accounts.name, account_category_user.account_role
        )
 SELECT get_parent_categories(child_category.slug) AS all_category_slugs,
    category_hierarchy.account_id,
    account.slug AS account_slug,
    child_category."position" AS child_category_position,
    child_category.id AS child_category_id,
    child_category.slug AS child_category_slug,
    child_category.reference AS child_category_reference,
    child_category.name AS child_category_name,
    bool_and(category_hierarchy.can_input) AS child_category_can_input,
    child_account_category.status AS child_category_status,
    COALESCE(child_progress.child_category_progress, 0::numeric) AS child_category_progress,
    COALESCE(json_agg(DISTINCT child_category_user.user_info::jsonb) FILTER (WHERE child_category_user.user_info IS NOT NULL), '[]'::json) AS child_category_users,
    COALESCE(json_agg(DISTINCT child_category_account.account_info::jsonb) FILTER (WHERE child_category_account.account_info IS NOT NULL), '[]'::json) AS child_category_accounts,
    parent_category."position" AS parent_category_position,
    parent_category.id AS parent_category_id,
    parent_category.slug AS parent_category_slug,
    parent_category.reference AS parent_category_reference,
    parent_category.name AS parent_category_name,
    parent_account_category.can_input AS parent_category_can_input,
    parent_account_category.status AS parent_category_status,
    COALESCE(parent_progress.parent_category_progress, 0::numeric) AS parent_category_progress
   FROM category_hierarchy
     LEFT JOIN category child_category ON child_category.id = category_hierarchy.category_id
     LEFT JOIN category parent_category ON parent_category.id = child_category.parent_category_id
     LEFT JOIN parent_progress ON parent_progress.account_id = category_hierarchy.account_id AND parent_progress.parent_category_slug::text = parent_category.slug::text
     LEFT JOIN child_progress ON child_progress.account_id = category_hierarchy.account_id AND child_progress.category_id = category_hierarchy.category_id
     LEFT JOIN basejump.accounts account ON account.id = category_hierarchy.account_id
     LEFT JOIN account_category child_account_category ON child_account_category.category_id = category_hierarchy.category_id AND child_account_category.account_id = category_hierarchy.account_id
     LEFT JOIN account_category parent_account_category ON parent_account_category.category_id = parent_category.id AND parent_account_category.account_id = category_hierarchy.account_id
     LEFT JOIN child_category_user ON child_category_user.category_id = category_hierarchy.category_id AND child_category_user.account_id = category_hierarchy.account_id
     LEFT JOIN child_category_account ON child_category_account.owner_account_id = category_hierarchy.account_id AND child_category_account.category_id = category_hierarchy.category_id
  GROUP BY category_hierarchy.account_id, account.slug, child_category.id, child_category.name, child_category.reference, child_category.slug, child_category."position", child_account_category.status, child_progress.child_category_progress, parent_category.id, parent_category.name, parent_category.reference, parent_category.slug, parent_category."position", parent_account_category.status, parent_progress.parent_category_progress, parent_account_category.can_input
  ORDER BY category_hierarchy.account_id, parent_category."position", child_category."position";

view_category_submissions

view

Column	Type
`parent_category_id`	`bigint`
`category_id`	`bigint`
`category_slug`	`character varying`
`category_name`	`character varying`
`category_description`	`text`
`category_ai_instructions`	`text`
`position`	`integer`
`account_id`	`uuid`
`year`	`smallint`
`content`	`jsonb`
`comments`	`text`
`requirements_status`	`jsonb`

SELECT category.parent_category_id,
    category.id AS category_id,
    category.slug AS category_slug,
    category.name AS category_name,
    category.description AS category_description,
    category.ai_instructions AS category_ai_instructions,
    category."position",
    category_submission.account_id,
    category_submission.year,
    category_submission.content,
    category_submission.comments,
    category_submission.requirements_status
   FROM category
     LEFT JOIN category_submission ON category.id = category_submission.category_id
  ORDER BY category.parent_category_id, category."position";

view_emission_factors

view

Column	Type
`id`	`bigint`
`created_at`	`timestamp with time zone`
`account_id`	`uuid`
`account_name`	`text`
`name`	`character varying`
`year`	`smallint`
`category_id`	`bigint`
`category_name`	`character varying`
`nace_category_id`	`integer`
`nace_category_name`	`text`
`country_id`	`integer`
`country_name`	`text`
`co2_per_unit`	`double precision`
`unit`	`character varying`
`scope_1_factor`	`double precision`
`scope_2_factor`	`double precision`

SELECT ef.id,
    ef.created_at,
    ef.account_id,
    acc.name AS account_name,
    ef.name,
    ef.year,
    ef.category_id,
    c.name AS category_name,
    ef.nace_category_id,
    nc.name AS nace_category_name,
    ef.country_id,
    co.name AS country_name,
    ef.co2_per_unit,
    ef.unit,
    ef.scope_1_factor,
    ef.scope_2_factor
   FROM emission_factor ef
     LEFT JOIN category c ON ef.category_id = c.id
     LEFT JOIN nace_category nc ON ef.nace_category_id = nc.id
     LEFT JOIN country co ON ef.country_id = co.id
     LEFT JOIN basejump.accounts acc ON ef.account_id = acc.id;

view_imported_list_errors

view

Column	Type
`comment_prefix`	`text`
`file_name`	`text`
`count`	`bigint`

SELECT "left"(imported_list.comment, 90) AS comment_prefix,
    imported_list.file_name,
    count(*) AS count
   FROM imported_list
  WHERE imported_list.status = 'error'::process_status
  GROUP BY ("left"(imported_list.comment, 90)), imported_list.file_name
  ORDER BY (count(*)) DESC;

view_imported_list_status

view

Column	Type
`status`	`process_status`
`file_name`	`text`
`row_count`	`bigint`

SELECT imported_list.status,
    imported_list.file_name,
    count(*) AS row_count
   FROM imported_list
  GROUP BY imported_list.status, imported_list.file_name
  ORDER BY imported_list.status, (count(*)) DESC;

view_suppliers

view

Column	Type
`id`	`integer`
`account_id`	`uuid`
`other_account_id`	`uuid`
`include_share`	`smallint`
`from_date`	`date`
`primary_owner_user_id`	`uuid`
`name`	`text`
`slug`	`text`
`organization_number`	`character varying(30)`
`business_description`	`text`
`website_url`	`character varying(255)`
`nace_category_id`	`integer`
`nace_category_name`	`text`
`emission_factor_id`	`integer`
`emission_factor_name`	`character varying`
`private_metadata`	`jsonb`
`public_metadata`	`jsonb`

SELECT aac.id,
    aac.account_id,
    aac.other_account_id,
    aac.include_share,
    aac.from_date,
    sup.primary_owner_user_id,
    sup.name,
    sup.slug,
    sup.organization_number,
    sup.business_description,
    sup.website_url,
    sup.nace_category_id,
    nace.name AS nace_category_name,
    sup.emission_factor_id,
    ef.name AS emission_factor_name,
    sup.private_metadata,
    sup.public_metadata
   FROM account_account aac
     LEFT JOIN basejump.accounts sup ON aac.other_account_id = sup.id
     LEFT JOIN nace_category nace ON sup.nace_category_id = nace.id
     LEFT JOIN emission_factor ef ON sup.emission_factor_id = ef.id
  WHERE aac.relation = 'customer-to'::account_relation_type
  ORDER BY sup.name;

Functions (358)

_pgr_alphashape(text, alpha double precision DEFAULT 0, OUT seq1 bigint, OUT textgeom text)

Returns: SETOF record
Language: c
Kind: function

pgrouting internal function

_pgr_array_reverse(anyarray)

Returns: anyarray
Language: sql
Kind: function

pgRouting internal function

_pgr_articulationpoints(edges_sql text, OUT seq integer, OUT node bigint)

Returns: SETOF record
Language: c
Kind: function

pgRouting internal function

_pgr_astar(edges_sql text, start_vids anyarray, end_vids anyarray, directed boolean DEFAULT true, heuristic integer DEFAULT 5, factor double precision DEFAULT 1.0, epsilon double precision DEFAULT 1.0, only_cost boolean DEFAULT false, normal boolean DEFAULT true, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: c
Kind: function

pgRouting internal function

_pgr_astar(edges_sql text, combinations_sql text, directed boolean DEFAULT true, heuristic integer DEFAULT 5, factor double precision DEFAULT 1.0, epsilon double precision DEFAULT 1.0, only_cost boolean DEFAULT false, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: c
Kind: function

pgRouting internal function

_pgr_bdastar(text, anyarray, anyarray, directed boolean DEFAULT true, heuristic integer DEFAULT 5, factor double precision DEFAULT 1.0, epsilon double precision DEFAULT 1.0, only_cost boolean DEFAULT false, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: c
Kind: function

pgRouting internal function

_pgr_bdastar(text, text, directed boolean DEFAULT true, heuristic integer DEFAULT 5, factor double precision DEFAULT 1.0, epsilon double precision DEFAULT 1.0, only_cost boolean DEFAULT false, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: c
Kind: function

pgRouting internal function

_pgr_bddijkstra(text, anyarray, anyarray, directed boolean, only_cost boolean DEFAULT false, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: c
Kind: function

pgRouting internal function

_pgr_bddijkstra(text, text, directed boolean, only_cost boolean DEFAULT false, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: c
Kind: function

pgRouting internal function

_pgr_bellmanford(edges_sql text, from_vids anyarray, to_vids anyarray, directed boolean, only_cost boolean, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: c
Kind: function

pgRouting internal function

_pgr_bellmanford(edges_sql text, combinations_sql text, directed boolean, only_cost boolean, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: c
Kind: function

pgRouting internal function

_pgr_biconnectedcomponents(edges_sql text, OUT seq bigint, OUT component bigint, OUT edge bigint)

Returns: SETOF record
Language: c
Kind: function

pgRouting internal function

_pgr_binarybreadthfirstsearch(edges_sql text, from_vids anyarray, to_vids anyarray, directed boolean DEFAULT true, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: c
Kind: function

pgRouting internal function

_pgr_binarybreadthfirstsearch(edges_sql text, combinations_sql text, directed boolean DEFAULT true, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: c
Kind: function

pgRouting internal function

_pgr_bipartite(edges_sql text, OUT node bigint, OUT color bigint)

Returns: SETOF record
Language: c
Kind: function

pgRouting internal function

_pgr_boost_version()

Returns: text
Language: c
Kind: function

pgRouting internal function

_pgr_breadthfirstsearch(edges_sql text, from_vids anyarray, max_depth bigint, directed boolean, OUT seq bigint, OUT depth bigint, OUT start_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: c
Kind: function

pgRouting internal function

_pgr_bridges(edges_sql text, OUT seq integer, OUT edge bigint)

Returns: SETOF record
Language: c
Kind: function

pgRouting internal function

_pgr_build_type()

Returns: text
Language: c
Kind: function

pgRouting internal function

_pgr_checkcolumn(text, text, text, is_optional boolean DEFAULT false, dryrun boolean DEFAULT false)

Returns: boolean
Language: plpgsql
Kind: function

_pgr_checkColumn is an internal function

_pgr_checkquery(text)

Returns: text
Language: plpgsql
Kind: function

_pgr_checkquery is an internal function

_pgr_checkverttab(vertname text, columnsarr text[], reporterrs integer DEFAULT 1, fnname text DEFAULT '_pgr_checkVertTab'::text, OUT sname text, OUT vname text)

Returns: record
Language: plpgsql
Kind: function

pgRouting internal function

_pgr_chinesepostman(edges_sql text, only_cost boolean, OUT seq integer, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: c
Kind: function

pgRouting internal function

_pgr_compilation_date()

Returns: text
Language: c
Kind: function

pgRouting internal function

_pgr_compiler_version()

Returns: text
Language: c
Kind: function

pgRouting internal function

_pgr_connectedcomponents(edges_sql text, OUT seq bigint, OUT component bigint, OUT node bigint)

Returns: SETOF record
Language: c
Kind: function

pgRouting internal function

_pgr_contraction(edges_sql text, contraction_order bigint[], max_cycles integer DEFAULT 1, forbidden_vertices bigint[] DEFAULT ARRAY[]::bigint[], directed boolean DEFAULT true, OUT type text, OUT id bigint, OUT contracted_vertices bigint[], OUT source bigint, OUT target bigint, OUT cost double precision)

Returns: SETOF record
Language: c
Kind: function

pgRouting internal function

_pgr_createindex(sname text, tname text, colname text, indext text, reporterrs integer DEFAULT 1, fnname text DEFAULT '_pgr_createIndex'::text)

Returns: void
Language: plpgsql
Kind: function

pgRouting internal function

_pgr_createindex(tabname text, colname text, indext text, reporterrs integer DEFAULT 1, fnname text DEFAULT '_pgr_createIndex'::text)

Returns: void
Language: plpgsql
Kind: function

pgRouting internal function

_pgr_cuthillmckeeordering(text, OUT seq bigint, OUT node bigint)

Returns: SETOF record
Language: c
Kind: function

pgRouting internal function

_pgr_dagshortestpath(text, anyarray, anyarray, directed boolean DEFAULT true, only_cost boolean DEFAULT false, OUT seq integer, OUT path_seq integer, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: c
Kind: function

pgRouting internal function

_pgr_dagshortestpath(text, text, directed boolean DEFAULT true, only_cost boolean DEFAULT false, OUT seq integer, OUT path_seq integer, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: c
Kind: function

pgRouting internal function

_pgr_depthfirstsearch(edges_sql text, root_vids anyarray, directed boolean, max_depth bigint, OUT seq bigint, OUT depth bigint, OUT start_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: c
Kind: function

pgRouting internal function

_pgr_dijkstra(edges_sql text, start_vids anyarray, end_vids anyarray, directed boolean, only_cost boolean, normal boolean, n_goals bigint, global boolean, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: c
Kind: function

pgRouting internal function

_pgr_dijkstra(edges_sql text, combinations_sql text, directed boolean, only_cost boolean, n_goals bigint, global boolean, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: c
Kind: function

pgRouting internal function

_pgr_dijkstra(edges_sql text, start_vids anyarray, end_vids anyarray, directed boolean DEFAULT true, only_cost boolean DEFAULT false, normal boolean DEFAULT true, n_goals bigint DEFAULT 0, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: c
Kind: function

pgRouting internal function

_pgr_dijkstra(edges_sql text, combinations_sql text, directed boolean DEFAULT true, only_cost boolean DEFAULT false, normal boolean DEFAULT true, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: c
Kind: function

pgRouting internal function

_pgr_dijkstranear(text, bigint, anyarray, bigint, directed boolean DEFAULT true, OUT seq integer, OUT path_seq integer, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgRouting internal function

_pgr_dijkstranear(text, anyarray, bigint, bigint, directed boolean DEFAULT true, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgRouting internal function

_pgr_dijkstranear(text, anyarray, anyarray, bigint, directed boolean DEFAULT true, OUT seq integer, OUT path_seq integer, OUT end_vid bigint, OUT start_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgRouting internal function

_pgr_dijkstravia(edges_sql text, via_vids anyarray, directed boolean, strict boolean, u_turn_on_edge boolean, OUT seq integer, OUT path_id integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision, OUT route_agg_cost double precision)

Returns: SETOF record
Language: c
Kind: function

pgRouting internal function

_pgr_drivingdistance(edges_sql text, start_vids anyarray, distance double precision, directed boolean DEFAULT true, equicost boolean DEFAULT false, OUT seq integer, OUT from_v bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: c
Kind: function

pgRouting internal function

_pgr_edgecoloring(edges_sql text, OUT edge_id bigint, OUT color_id bigint)

Returns: SETOF record
Language: c
Kind: function

pgRouting internal function

_pgr_edgedisjointpaths(text, anyarray, anyarray, directed boolean, OUT seq integer, OUT path_id integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: c
Kind: function

pgRouting internal function

_pgr_edgedisjointpaths(text, text, directed boolean, OUT seq integer, OUT path_id integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: c
Kind: function

pgRouting internal function

_pgr_edwardmoore(edges_sql text, from_vids anyarray, to_vids anyarray, directed boolean DEFAULT true, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: c
Kind: function

pgRouting internal function

_pgr_edwardmoore(edges_sql text, combinations_sql text, directed boolean DEFAULT true, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: c
Kind: function

pgRouting internal function

_pgr_endpoint(g gis.geometry)

Returns: gis.geometry
Language: sql
Kind: function

pgRouting internal function

_pgr_floydwarshall(edges_sql text, directed boolean, OUT start_vid bigint, OUT end_vid bigint, OUT agg_cost double precision)

Returns: SETOF record
Language: c
Kind: function

pgRouting internal function

_pgr_get_statement(o_sql text)

Returns: text
Language: plpgsql
Kind: function

pgRouting internal function

_pgr_getcolumnname(sname text, tname text, col text, reporterrs integer DEFAULT 1, fnname text DEFAULT '_pgr_getColumnName'::text)

Returns: text
Language: plpgsql
Kind: function

pgRouting internal function

_pgr_getcolumnname(tab text, col text, reporterrs integer DEFAULT 1, fnname text DEFAULT '_pgr_getColumnName'::text)

Returns: text
Language: plpgsql
Kind: function

pgRouting internal function

_pgr_getcolumntype(sname text, tname text, cname text, reporterrs integer DEFAULT 0, fnname text DEFAULT '_pgr_getColumnType'::text)

Returns: text
Language: plpgsql
Kind: function

pgRouting internal function

_pgr_getcolumntype(tab text, col text, reporterrs integer DEFAULT 0, fnname text DEFAULT '_pgr_getColumnType'::text)

Returns: text
Language: plpgsql
Kind: function

pgRouting internal function

_pgr_gettablename(tab text, reporterrs integer DEFAULT 0, fnname text DEFAULT '_pgr_getTableName'::text, OUT sname text, OUT tname text)

Returns: record
Language: plpgsql
Kind: function

pgRouting internal function

_pgr_git_hash()

Returns: text
Language: c
Kind: function

pgRouting internal function

_pgr_hawickcircuits(text, OUT seq integer, OUT path_id integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: c
Kind: function

pgRouting internal function

_pgr_iscolumnindexed(sname text, tname text, cname text, reporterrs integer DEFAULT 1, fnname text DEFAULT '_pgr_isColumnIndexed'::text)

Returns: boolean
Language: plpgsql
Kind: function

pgRouting internal function

_pgr_iscolumnindexed(tab text, col text, reporterrs integer DEFAULT 1, fnname text DEFAULT '_pgr_isColumnIndexed'::text)

Returns: boolean
Language: plpgsql
Kind: function

pgRouting internal function

_pgr_iscolumnintable(tab text, col text)

Returns: boolean
Language: plpgsql
Kind: function

pgRouting internal function

_pgr_isplanar(text)

Returns: boolean
Language: c
Kind: function

pgRouting internal function

_pgr_johnson(edges_sql text, directed boolean, OUT start_vid bigint, OUT end_vid bigint, OUT agg_cost double precision)

Returns: SETOF record
Language: c
Kind: function

pgRouting internal function

_pgr_kruskal(text, anyarray, fn_suffix text, max_depth bigint, distance double precision, OUT seq bigint, OUT depth bigint, OUT start_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: c
Kind: function

pgRouting internal function

_pgr_ksp(edges_sql text, start_vid bigint, end_vid bigint, k integer, directed boolean, heap_paths boolean, OUT seq integer, OUT path_id integer, OUT path_seq integer, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: c
Kind: function

pgRouting internal function

_pgr_lengauertarjandominatortree(edges_sql text, root_vid bigint, OUT seq integer, OUT vid bigint, OUT idom bigint)

Returns: SETOF record
Language: c
Kind: function

pgRouting internal function

_pgr_lib_version()

Returns: text
Language: c
Kind: function

pgRouting internal function

_pgr_linegraph(text, directed boolean, OUT seq integer, OUT source bigint, OUT target bigint, OUT cost double precision, OUT reverse_cost double precision)

Returns: SETOF record
Language: c
Kind: function

pgRouting internal function

_pgr_linegraphfull(text, OUT seq integer, OUT source bigint, OUT target bigint, OUT cost double precision, OUT edge bigint)

Returns: SETOF record
Language: c
Kind: function

pgRouting internal function

_pgr_makeconnected(text, OUT seq bigint, OUT start_vid bigint, OUT end_vid bigint)

Returns: SETOF record
Language: c
Kind: function

pgRouting internal function

_pgr_maxcardinalitymatch(edges_sql text, directed boolean, OUT seq integer, OUT edge bigint, OUT source bigint, OUT target bigint)

Returns: SETOF record
Language: c
Kind: function

pgRouting internal function

_pgr_maxflow(edges_sql text, sources anyarray, targets anyarray, algorithm integer DEFAULT 1, only_flow boolean DEFAULT false, OUT seq integer, OUT edge_id bigint, OUT source bigint, OUT target bigint, OUT flow bigint, OUT residual_capacity bigint)

Returns: SETOF record
Language: c
Kind: function

pgRouting internal function

_pgr_maxflow(edges_sql text, combinations_sql text, algorithm integer DEFAULT 1, only_flow boolean DEFAULT false, OUT seq integer, OUT edge_id bigint, OUT source bigint, OUT target bigint, OUT flow bigint, OUT residual_capacity bigint)

Returns: SETOF record
Language: c
Kind: function

pgRouting internal function

_pgr_maxflowmincost(edges_sql text, sources anyarray, targets anyarray, only_cost boolean DEFAULT false, OUT seq integer, OUT edge bigint, OUT source bigint, OUT target bigint, OUT flow bigint, OUT residual_capacity bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: c
Kind: function

pgRouting internal function

_pgr_maxflowmincost(edges_sql text, combinations_sql text, only_cost boolean DEFAULT false, OUT seq integer, OUT edge bigint, OUT source bigint, OUT target bigint, OUT flow bigint, OUT residual_capacity bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: c
Kind: function

pgRouting internal function

_pgr_msg(msgkind integer, fnname text, msg text DEFAULT '---->OK'::text)

Returns: void
Language: plpgsql
Kind: function

pgRouting internal function

_pgr_onerror(errcond boolean, reporterrs integer, fnname text, msgerr text, hinto text DEFAULT 'No hint'::text, msgok text DEFAULT 'OK'::text)

Returns: void
Language: plpgsql
Kind: function

pgRouting internal function

_pgr_operating_system()

Returns: text
Language: c
Kind: function

pgRouting internal function

_pgr_parameter_check(fn text, sql text, big boolean DEFAULT false)

Returns: boolean
Language: plpgsql
Kind: function

pgRouting internal function

_pgr_pgsql_version()

Returns: text
Language: c
Kind: function

pgRouting internal function

_pgr_pickdeliver(text, text, text, factor double precision DEFAULT 1, max_cycles integer DEFAULT 10, initial_sol integer DEFAULT 4, OUT seq integer, OUT vehicle_seq integer, OUT vehicle_id bigint, OUT stop_seq integer, OUT stop_type integer, OUT stop_id bigint, OUT order_id bigint, OUT cargo double precision, OUT travel_time double precision, OUT arrival_time double precision, OUT wait_time double precision, OUT service_time double precision, OUT departure_time double precision)

Returns: SETOF record
Language: c
Kind: function

pgRouting internal function

_pgr_pickdelivereuclidean(text, text, factor double precision DEFAULT 1, max_cycles integer DEFAULT 10, initial_sol integer DEFAULT 4, OUT seq integer, OUT vehicle_seq integer, OUT vehicle_id bigint, OUT stop_seq integer, OUT stop_type integer, OUT order_id bigint, OUT cargo double precision, OUT travel_time double precision, OUT arrival_time double precision, OUT wait_time double precision, OUT service_time double precision, OUT departure_time double precision)

Returns: SETOF record
Language: c
Kind: function

pgRouting internal function

_pgr_pointtoid(point gis.geometry, tolerance double precision, vertname text, srid integer)

Returns: bigint
Language: plpgsql
Kind: function

pgRouting internal function

_pgr_prim(text, anyarray, order_by text, max_depth bigint, distance double precision, OUT seq bigint, OUT depth bigint, OUT start_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: c
Kind: function

pgRouting internal function

_pgr_quote_ident(idname text)

Returns: text
Language: plpgsql
Kind: function

pgRouting internal function

_pgr_sequentialvertexcoloring(edges_sql text, OUT vertex_id bigint, OUT color_id bigint)

Returns: SETOF record
Language: c
Kind: function

pgRouting internal function

_pgr_startpoint(g gis.geometry)

Returns: gis.geometry
Language: sql
Kind: function

pgRouting internal function

_pgr_stoerwagner(edges_sql text, OUT seq integer, OUT edge bigint, OUT cost double precision, OUT mincut double precision)

Returns: SETOF record
Language: c
Kind: function

pgRouting internal function

_pgr_strongcomponents(edges_sql text, OUT seq bigint, OUT component bigint, OUT node bigint)

Returns: SETOF record
Language: c
Kind: function

pgRouting internal function

_pgr_topologicalsort(edges_sql text, OUT seq integer, OUT sorted_v bigint)

Returns: SETOF record
Language: c
Kind: function

pgRouting internal function

_pgr_transitiveclosure(edges_sql text, OUT seq integer, OUT vid bigint, OUT target_array bigint[])

Returns: SETOF record
Language: c
Kind: function

pgRouting internal function

_pgr_trsp(text, text, bigint, bigint, directed boolean DEFAULT true, OUT seq integer, OUT path_seq integer, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgRouting internal function

_pgr_trsp(text, text, bigint, anyarray, directed boolean DEFAULT true, OUT seq integer, OUT path_seq integer, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgRouting internal function

_pgr_trsp(text, text, anyarray, bigint, directed boolean DEFAULT true, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgRouting internal function

_pgr_trsp(text, text, anyarray, anyarray, directed boolean DEFAULT true, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgRouting internal function

_pgr_trsp(sql text, source_eid integer, source_pos double precision, target_eid integer, target_pos double precision, directed boolean, has_reverse_cost boolean, turn_restrict_sql text DEFAULT NULL::text, OUT seq integer, OUT id1 integer, OUT id2 integer, OUT cost double precision)

Returns: SETOF record
Language: c
Kind: function

pgRouting internal function

_pgr_trsp_withpoints(text, text, text, anyarray, anyarray, directed boolean, driving_side character, details boolean, OUT seq integer, OUT path_seq integer, OUT departure bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: c
Kind: function

pgRouting internal function

_pgr_trsp_withpoints(text, text, text, text, directed boolean, driving_side character, details boolean, OUT seq integer, OUT path_seq integer, OUT departure bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: c
Kind: function

pgRouting internal function

_pgr_trspvia(text, text, anyarray, boolean, boolean, boolean, OUT seq integer, OUT path_id integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision, OUT route_agg_cost double precision)

Returns: SETOF record
Language: c
Kind: function

pgRouting internal function

_pgr_trspvia_withpoints(text, text, text, anyarray, boolean, boolean, boolean, character, boolean, OUT seq integer, OUT path_id integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision, OUT route_agg_cost double precision)

Returns: SETOF record
Language: c
Kind: function

pgRouting internal function

_pgr_trspviavertices(sql text, vids integer[], directed boolean, has_rcost boolean, turn_restrict_sql text DEFAULT NULL::text, OUT seq integer, OUT id1 integer, OUT id2 integer, OUT id3 integer, OUT cost double precision)

Returns: SETOF record
Language: plpgsql
Kind: function

pgRouting internal function

_pgr_tsp(matrix_row_sql text, start_id bigint DEFAULT 0, end_id bigint DEFAULT 0, max_processing_time double precision DEFAULT 'Infinity'::double precision, tries_per_temperature integer DEFAULT 500, max_changes_per_temperature integer DEFAULT 60, max_consecutive_non_changes integer DEFAULT 100, initial_temperature double precision DEFAULT 100, final_temperature double precision DEFAULT 0.1, cooling_factor double precision DEFAULT 0.9, randomize boolean DEFAULT true, OUT seq integer, OUT node bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: c
Kind: function

pgRouting internal function

_pgr_tspeuclidean(coordinates_sql text, start_id bigint DEFAULT 0, end_id bigint DEFAULT 0, max_processing_time double precision DEFAULT 'Infinity'::double precision, tries_per_temperature integer DEFAULT 500, max_changes_per_temperature integer DEFAULT 60, max_consecutive_non_changes integer DEFAULT 100, initial_temperature double precision DEFAULT 100, final_temperature double precision DEFAULT 0.1, cooling_factor double precision DEFAULT 0.9, randomize boolean DEFAULT true, OUT seq integer, OUT node bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: c
Kind: function

pgRouting internal function

_pgr_turnrestrictedpath(text, text, bigint, bigint, integer, directed boolean, heap_paths boolean, stop_on_first boolean, strict boolean, OUT seq integer, OUT path_id integer, OUT path_seq integer, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: c
Kind: function

pgRouting internal function

_pgr_versionless(v1 text, v2 text)

Returns: boolean
Language: plpgsql
Kind: function

pgRouting internal function

_pgr_vrponedepot(text, text, text, integer, OUT seq integer, OUT vehicle_seq integer, OUT vehicle_id bigint, OUT stop_seq integer, OUT stop_type integer, OUT stop_id bigint, OUT order_id bigint, OUT cargo double precision, OUT travel_time double precision, OUT arrival_time double precision, OUT wait_time double precision, OUT service_time double precision, OUT departure_time double precision)

Returns: SETOF record
Language: plpgsql
Kind: function

pgRouting internal function

_pgr_withpoints(edges_sql text, points_sql text, start_pids anyarray, end_pids anyarray, directed boolean, driving_side character, details boolean, only_cost boolean DEFAULT false, normal boolean DEFAULT true, OUT seq integer, OUT path_seq integer, OUT start_pid bigint, OUT end_pid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: c
Kind: function

pgRouting internal function

_pgr_withpoints(edges_sql text, points_sql text, combinations_sql text, directed boolean, driving_side character, details boolean, only_cost boolean DEFAULT false, OUT seq integer, OUT path_seq integer, OUT start_pid bigint, OUT end_pid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: c
Kind: function

pgRouting internal function

_pgr_withpointsdd(edges_sql text, points_sql text, start_pid anyarray, distance double precision, directed boolean DEFAULT true, driving_side character DEFAULT 'b'::bpchar, details boolean DEFAULT false, equicost boolean DEFAULT false, OUT seq integer, OUT start_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: c
Kind: function

pgRouting internal function

_pgr_withpointsksp(edges_sql text, points_sql text, start_pid bigint, end_pid bigint, k integer, directed boolean, heap_paths boolean, driving_side character, details boolean, OUT seq integer, OUT path_id integer, OUT path_seq integer, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: c
Kind: function

pgRouting internal function

_pgr_withpointsvia(text, text, anyarray, boolean, boolean, boolean, character, boolean, OUT seq integer, OUT path_id integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision, OUT route_agg_cost double precision)

Returns: SETOF record
Language: c
Kind: function

pgRouting internal function

_pgr_withpointsvia(sql text, via_edges bigint[], fraction double precision[], directed boolean DEFAULT true, OUT seq integer, OUT path_id integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision, OUT route_agg_cost double precision)

Returns: SETOF record
Language: plpgsql
Kind: function

pgRouting internal function DEPRECATED on v3.4.0

_trsp(text, text, anyarray, anyarray, directed boolean DEFAULT true, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: c
Kind: function

pgRouting internal function

_v4trsp(text, text, anyarray, anyarray, directed boolean DEFAULT true, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: c
Kind: function

pgRouting internal function

_v4trsp(text, text, text, directed boolean DEFAULT true, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: c
Kind: function

pgRouting internal function

accept_invitation(lookup_invitation_token text)

Returns: jsonb
Language: plpgsql
Kind: function
SECURITY DEFINER

add_account_category_user_trigger()

Returns: trigger
Language: plpgsql
Kind: function

add_enum_value_if_not_exists(enum_name text, new_value text)

Returns: void
Language: plpgsql
Kind: function

Safely adds a new value to an enum type if it does not already exist. Parameters: enum_name - Name of the enum type new_value - Value to add to the enum This function is idempotent and safe for use in migration scripts. Example: SELECT add_enum_value_if_not_exists('process_status', 'in-progress')

check_order_access(dist_contract_id bigint)

Returns: boolean
Language: plpgsql
Kind: function
SECURITY DEFINER

create_account(slug text DEFAULT NULL::text, name text DEFAULT NULL::text)

Returns: json
Language: plpgsql
Kind: function

create_invitation(account_id uuid, account_role basejump.account_role, invitation_type basejump.invitation_type)

Returns: json
Language: plpgsql
Kind: function

create_invitation_by_email(account_id uuid, account_role basejump.account_role, invitation_type basejump.invitation_type, email text)

Returns: jsonb
Language: plpgsql
Kind: function

current_user_account_role(account_id uuid)

Returns: jsonb
Language: plpgsql
Kind: function

delete_account_category_user_trigger()

Returns: trigger
Language: plpgsql
Kind: function

delete_invitation(invitation_id uuid)

Returns: void
Language: plpgsql
Kind: function

get_account(account_id uuid)

Returns: json
Language: plpgsql
Kind: function

get_account_billing_status(account_id uuid)

Returns: jsonb
Language: plpgsql
Kind: function
SECURITY DEFINER

get_account_by_slug(slug text)

Returns: json
Language: plpgsql
Kind: function

get_account_id(slug text)

Returns: uuid
Language: sql
Kind: function

get_account_invitations(account_id uuid, results_limit integer DEFAULT 25, results_offset integer DEFAULT 0)

Returns: json
Language: plpgsql
Kind: function

get_account_members(account_id uuid, results_limit integer DEFAULT 50, results_offset integer DEFAULT 0)

Returns: json
Language: plpgsql
Kind: function
SECURITY DEFINER

get_account_slug(account_id uuid)

Returns: text
Language: plpgsql
Kind: function

get_accounts()

Returns: json
Language: sql
Kind: function
SECURITY DEFINER

get_accounts_with_category(category_slug text)

Returns: TABLE(id uuid, slug text, name text, status project_status)
Language: plpgsql
Kind: function

get_all_group_accounts(current_account_slug text)

Returns: TABLE(id uuid, parent_account_id uuid, name text, slug text, primary_owner_user_id uuid, primary_owner_user_email character varying, primary_owner_personal_account_id uuid, primary_owner_personal_account_name text)
Language: plpgsql
Kind: function
SECURITY DEFINER

get_child_accounts(parent_account_slug text)

Returns: TABLE(id uuid, parent_account_id uuid, name text, slug text)
Language: plpgsql
Kind: function
SECURITY DEFINER

get_customers_to(supplier_id uuid)

Returns: TABLE(id uuid, name text, slug text)
Language: sql
Kind: function

get_email_invitations(useremail text, results_limit integer DEFAULT 25, results_offset integer DEFAULT 0)

Returns: TABLE(id uuid, account_id uuid, account_name text, account_role basejump.account_role, created_at timestamp with time zone, email text, invitation_type basejump.invitation_type, invited_by_user_id uuid, token text, updated_at timestamp with time zone, members integer)
Language: plpgsql
Kind: function

get_import_status_counts_by_month(input_date date DEFAULT CURRENT_DATE)

Returns: TABLE(not_started bigint, errors bigint, in_progress bigint, completed bigint)
Language: plpgsql
Kind: function

get_invitation_by_token(invitation_token text)

Returns: TABLE(id uuid, account_id uuid, account_name text, account_role basejump.account_role, created_at timestamp with time zone, email text, invitation_type basejump.invitation_type, invited_by_user_id uuid, token text, updated_at timestamp with time zone, members integer)
Language: plpgsql
Kind: function
SECURITY DEFINER

get_letter_emissions()

Returns: TABLE(transporter_account_id uuid, name text, name_synonyms text[], di_letter text, vehicle_type_id integer, emissions_class text)
Language: plpgsql
Kind: function

get_parent_accounts(child_account_slug text)

Returns: TABLE(id uuid, parent_account_id uuid, name text, slug text)
Language: plpgsql
Kind: function

get_parent_categories(category_slug character varying)

Returns: character varying[]
Language: plpgsql
Kind: function

get_personal_account()

Returns: json
Language: plpgsql
Kind: function

get_view_categories_overview(account_slug character varying)

Returns: SETOF view_categories_overview
Language: plpgsql
Kind: function
SECURITY DEFINER

is_member_of_company_group(group_slug text)

Returns: boolean
Language: plpgsql
Kind: function

lookup_invitation(lookup_invitation_token text)

Returns: json
Language: plpgsql
Kind: function
SECURITY DEFINER

pgr_alphashape(gis.geometry, alpha double precision DEFAULT 0)

Returns: gis.geometry
Language: plpgsql
Kind: function

pgr_alphaShape

Parameters
- An SQL with columns: geom
Optional Parameters
- alpha := 0
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_alphaShape.html

pgr_analyzegraph(text, double precision, the_geom text DEFAULT 'the_geom'::text, id text DEFAULT 'id'::text, source text DEFAULT 'source'::text, target text DEFAULT 'target'::text, rows_where text DEFAULT 'true'::text)

Returns: character varying
Language: plpgsql
Kind: function

pgr_analyzeGraph

Parameters
- Edge table name
- tolerance
Optional parameters
- the_geom: default 'the_geom'
- id := 'id'
- source := 'source'
- target := 'target'
- rows_where := 'true'
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_analyzeGraph.html

pgr_analyzeoneway(text, text[], text[], text[], text[], two_way_if_null boolean DEFAULT true, oneway text DEFAULT 'oneway'::text, source text DEFAULT 'source'::text, target text DEFAULT 'target'::text)

Returns: text
Language: plpgsql
Kind: function

pgr_analyzeOneWay

Parameters
- edge table
- source in rules
- source out rules,
- target in rules
- target out rules,
Optional parameters
- two_way_if_null := true
- oneway := 'oneway',
- source := 'source'
- target:='target'
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_analyzeOneWay.html

pgr_articulationpoints(text, OUT node bigint)

Returns: SETOF bigint
Language: sql
Kind: function

pgr_articulationPoints

Undirected graph
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_articulationPoints.html

pgr_astar(text, bigint, bigint, directed boolean DEFAULT true, heuristic integer DEFAULT 5, factor double precision DEFAULT 1.0, epsilon double precision DEFAULT 1.0, OUT seq integer, OUT path_seq integer, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_aStar(One to One)

Parameters:
- edges SQL with columns: id, source, target, cost [,reverse_cost], x1, y1, x2, y2
- From vertex identifier
- To vertex identifier
Optional Parameters:
- directed := true
- heuristic := 5
- factor := 1
- epsilon := 1
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_aStar.html

pgr_astar(text, bigint, anyarray, directed boolean DEFAULT true, heuristic integer DEFAULT 5, factor double precision DEFAULT 1.0, epsilon double precision DEFAULT 1.0, OUT seq integer, OUT path_seq integer, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_aStar(One to Many)

Parameters:
- edges SQL with columns: id, source, target, cost [,reverse_cost], x1, y1, x2, y2
- From vertex identifier
- To ARRAY[vertices identifiers]
Optional Parameters:
- directed := true
- heuristic := 5
- factor := 1
- epsilon := 1
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_aStar.html

pgr_astar(text, anyarray, bigint, directed boolean DEFAULT true, heuristic integer DEFAULT 5, factor double precision DEFAULT 1.0, epsilon double precision DEFAULT 1.0, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_aStar(Many to One)

Parameters:
- edges SQL with columns: id, source, target, cost [,reverse_cost], x1, y1, x2, y2
- From ARRAY[vertices identifiers]
- To vertex identifier
Optional Parameters:
- directed := true
- heuristic := 5
- factor := 1
- epsilon := 1
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_aStar.html

pgr_astar(text, anyarray, anyarray, directed boolean DEFAULT true, heuristic integer DEFAULT 5, factor double precision DEFAULT 1.0, epsilon double precision DEFAULT 1.0, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_aStar(Many to Many)

Parameters:
- edges SQL with columns: id, source, target, cost [,reverse_cost], x1, y1, x2, y2
- From ARRAY[vertices identifiers]
- To ARRAY[vertices identifiers]
Optional Parameters:
- directed := true
- heuristic := 5
- factor := 1
- epsilon := 1
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_aStar.html

pgr_astar(text, text, directed boolean DEFAULT true, heuristic integer DEFAULT 5, factor double precision DEFAULT 1.0, epsilon double precision DEFAULT 1.0, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_aStar(Combinations)

Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost], x1, y1, x2, y2
- Combinations SQL with columns: source, target
Optional Parameters:
- directed := true
- heuristic := 5
- factor := 1
- epsilon := 1
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_aStar.html

pgr_astarcost(text, bigint, bigint, directed boolean DEFAULT true, heuristic integer DEFAULT 5, factor double precision DEFAULT 1.0, epsilon double precision DEFAULT 1.0, OUT start_vid bigint, OUT end_vid bigint, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_aStarCost(One to One)

Parameters:
- edges SQL with columns: id, source, target, cost [,reverse_cost], x1, y1, x2, y2
- From vertex identifier
- To vertex identifier
Optional Parameters:
- directed := true
- heuristic := 5
- factor := 1
- epsilon := 1
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_aStarCost.html

pgr_astarcost(text, bigint, anyarray, directed boolean DEFAULT true, heuristic integer DEFAULT 5, factor double precision DEFAULT 1.0, epsilon double precision DEFAULT 1.0, OUT start_vid bigint, OUT end_vid bigint, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_aStarCost(One to Many)

Parameters:
- edges SQL with columns: id, source, target, cost [,reverse_cost], x1, y1, x2, y2
- From vertex identifier
- To ARRAY[vertices identifiers]
Optional Parameters:
- directed := true
- heuristic := 5
- factor := 1
- epsilon := 1
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_aStarCost.html

pgr_astarcost(text, anyarray, bigint, directed boolean DEFAULT true, heuristic integer DEFAULT 5, factor double precision DEFAULT 1.0, epsilon double precision DEFAULT 1.0, OUT start_vid bigint, OUT end_vid bigint, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_aStarCost(Many to One)

Parameters:
- edges SQL with columns: id, source, target, cost [,reverse_cost], x1, y1, x2, y2
- From ARRAY[vertices identifiers]
- To vertex identifier
Optional Parameters:
- directed := true
- heuristic := 5
- factor := 1
- epsilon := 1
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_aStarCost.html

pgr_astarcost(text, anyarray, anyarray, directed boolean DEFAULT true, heuristic integer DEFAULT 5, factor double precision DEFAULT 1.0, epsilon double precision DEFAULT 1.0, OUT start_vid bigint, OUT end_vid bigint, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_aStarCost(Many to Many)

Parameters:
- edges SQL with columns: id, source, target, cost [,reverse_cost], x1, y1, x2, y2
- From ARRAY[vertices identifiers]
- To ARRAY[vertices identifiers]
Optional Parameters:
- directed := true
- heuristic := 5
- factor := 1
- epsilon := 1
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_aStarCost.html

pgr_astarcost(text, text, directed boolean DEFAULT true, heuristic integer DEFAULT 5, factor double precision DEFAULT 1.0, epsilon double precision DEFAULT 1.0, OUT start_vid bigint, OUT end_vid bigint, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_aStarCost(Combinations)

Parameters:
- edges SQL with columns: id, source, target, cost [,reverse_cost], x1, y1, x2, y2
- Combinations SQL with columns: source, target
Optional Parameters:
- directed := true
- heuristic := 5
- factor := 1
- epsilon := 1
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_aStarCost.html

pgr_astarcostmatrix(text, anyarray, directed boolean DEFAULT true, heuristic integer DEFAULT 5, factor double precision DEFAULT 1.0, epsilon double precision DEFAULT 1.0, OUT start_vid bigint, OUT end_vid bigint, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_aStarCostMatrix

Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost], x1, y1, x2, y2
- ARRAY [vertices identifiers]
Optional Parameters:
- directed := true
- heuristic := 5
- factor := 1
- epsilon := 1
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_aStarCostMatrix.html

pgr_bdastar(text, bigint, bigint, directed boolean DEFAULT true, heuristic integer DEFAULT 5, factor numeric DEFAULT 1.0, epsilon numeric DEFAULT 1.0, OUT seq integer, OUT path_seq integer, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_bdAstar(One to One)

Parameters:
- edges SQL with columns: id, source, target, cost [,reverse_cost], x1, y1, x2, y2
- From vertex identifier
- To vertex identifier
Optional Parameters:
- directed := true
- heuristic := 5
- factor := 1
- epsilon := 1
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_bdAstar.html

pgr_bdastar(text, bigint, anyarray, directed boolean DEFAULT true, heuristic integer DEFAULT 5, factor numeric DEFAULT 1.0, epsilon numeric DEFAULT 1.0, OUT seq integer, OUT path_seq integer, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_bdAstar(One to Many)

Parameters:
- edges SQL with columns: id, source, target, cost [,reverse_cost], x1, y1, x2, y2
- From vertex identifier
- To ARRAY[vertices identifiers]
Optional Parameters:
- directed := true
- heuristic := 5
- factor := 1
- epsilon := 1
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_bdAstar.html

pgr_bdastar(text, anyarray, bigint, directed boolean DEFAULT true, heuristic integer DEFAULT 5, factor numeric DEFAULT 1.0, epsilon numeric DEFAULT 1.0, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_bdAstar(Many to One)

Parameters:
- edges SQL with columns: id, source, target, cost [,reverse_cost], x1, y1, x2, y2
- From ARRAY[vertices identifiers]
- To vertex identifier
Optional Parameters:
- directed := true
- heuristic := 5
- factor := 1
- epsilon := 1
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_bdAstar.html

pgr_bdastar(text, anyarray, anyarray, directed boolean DEFAULT true, heuristic integer DEFAULT 5, factor numeric DEFAULT 1.0, epsilon numeric DEFAULT 1.0, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_bdAstar(Many to Many)

Parameters:
- edges SQL with columns: id, source, target, cost [,reverse_cost], x1, y1, x2, y2
- From ARRAY[vertices identifiers]
- To ARRAY[vertices identifiers]
Optional Parameters:
- directed := true
- heuristic := 5
- factor := 1
- epsilon := 1
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_bdAstar.html

pgr_bdastar(text, text, directed boolean DEFAULT true, heuristic integer DEFAULT 5, factor numeric DEFAULT 1.0, epsilon numeric DEFAULT 1.0, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_bdAstar(Combinations)

Parameters:
- Edges SQL with columns: id, source, target, cost [, reverse_cost], x1, y1, x2, y2
- Combinations SQL with columns: source, target
Optional Parameters:
- directed := true
- heuristic := 5
- factor := 1
- epsilon := 1
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_bdAstar.html

pgr_bdastarcost(text, bigint, bigint, directed boolean DEFAULT true, heuristic integer DEFAULT 5, factor numeric DEFAULT 1.0, epsilon numeric DEFAULT 1.0, OUT start_vid bigint, OUT end_vid bigint, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_bdAstarCost(One to One)

Parameters:
- edges SQL with columns: id, source, target, cost [,reverse_cost], x1, y1, x2, y2
- From vertex identifier
- To vertex identifier
Optional Parameters:
- directed := true
- heuristic := 5
- factor := 1
- epsilon := 1
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_bdAstarCost.html

pgr_bdastarcost(text, bigint, anyarray, directed boolean DEFAULT true, heuristic integer DEFAULT 5, factor numeric DEFAULT 1.0, epsilon numeric DEFAULT 1.0, OUT start_vid bigint, OUT end_vid bigint, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_bdAstarCost(One to Many)

Parameters:
- edges SQL with columns: id, source, target, cost [,reverse_cost], x1, y1, x2, y2
- From vertex identifier
- To ARRAY[vertices identifiers]
Optional Parameters:
- directed := true
- heuristic := 5
- factor := 1
- epsilon := 1
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_bdAstarCost.html

pgr_bdastarcost(text, anyarray, bigint, directed boolean DEFAULT true, heuristic integer DEFAULT 5, factor numeric DEFAULT 1.0, epsilon numeric DEFAULT 1.0, OUT start_vid bigint, OUT end_vid bigint, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_bdAstarCost(Many to One)

Parameters:
- edges SQL with columns: id, source, target, cost [,reverse_cost], x1, y1, x2, y2
- From ARRAY[vertices identifiers]
- To vertex identifier
Optional Parameters:
- directed := true
- heuristic := 5
- factor := 1
- epsilon := 1
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_bdAstarCost.html

pgr_bdastarcost(text, anyarray, anyarray, directed boolean DEFAULT true, heuristic integer DEFAULT 5, factor numeric DEFAULT 1.0, epsilon numeric DEFAULT 1.0, OUT start_vid bigint, OUT end_vid bigint, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_bdAstarCost(Many to Many)

Parameters:
- edges SQL with columns: id, source, target, cost [,reverse_cost], x1, y1, x2, y2
- From ARRAY[vertices identifiers]
- To ARRAY[vertices identifiers]
Optional Parameters:
- directed := true
- heuristic := 5
- factor := 1
- epsilon := 1
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_bdAstarCost.html

pgr_bdastarcost(text, text, directed boolean DEFAULT true, heuristic integer DEFAULT 5, factor numeric DEFAULT 1.0, epsilon numeric DEFAULT 1.0, OUT start_vid bigint, OUT end_vid bigint, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_bdAstarCost(Combinations)

Parameters:
- Edges SQL with columns: id, source, target, cost [, reverse_cost], x1, y1, x2, y2
- Combinations SQL with columns: source, target
Optional Parameters:
- directed := true
- heuristic := 5
- factor := 1
- epsilon := 1
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_bdAstarCost.html

pgr_bdastarcostmatrix(text, anyarray, directed boolean DEFAULT true, heuristic integer DEFAULT 5, factor numeric DEFAULT 1.0, epsilon numeric DEFAULT 1.0, OUT start_vid bigint, OUT end_vid bigint, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_bdAstarCostMatrix

Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost], x1, y1, x2, y2
- ARRAY [vertices identifiers]
Optional Parameters:
- directed := true
- heuristic := 5
- factor := 1
- epsilon := 1
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_bdAstarCostMatrix.html

pgr_bddijkstra(text, bigint, bigint, directed boolean DEFAULT true, OUT seq integer, OUT path_seq integer, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_bdDijkstra(One to One)

Parameters:
- edges SQL with columns: id, source, target, cost [,reverse_cost]
- From vertex identifier
- To vertex identifier
Optional Parameters:
- directed := true
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_bdDijkstra.html

pgr_bddijkstra(text, bigint, anyarray, directed boolean DEFAULT true, OUT seq integer, OUT path_seq integer, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_bdDijkstra(One to Many)

Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- From vertex identifier
- To ARRAY[vertices identifiers]
Optional Parameters
- directed := true
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_bdDijkstra.html

pgr_bddijkstra(text, anyarray, bigint, directed boolean DEFAULT true, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_bdDijkstra(Many to One)

Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- From ARRAY[vertices identifiers]
- To vertex identifier
Optional Parameters
- directed := true
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_bdDijkstra.html

pgr_bddijkstra(text, anyarray, anyarray, directed boolean DEFAULT true, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_bdDijkstra(Many to Many)

Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- From ARRAY[vertices identifiers]
- To ARRAY[vertices identifiers]
Optional Parameters
- directed := true
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_bdDijkstra.html

pgr_bddijkstra(text, text, directed boolean DEFAULT true, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_bdDijkstra(Combinations)

Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- Combinations SQL with columns: source, target
Optional Parameters
- directed := true
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_bdDijkstra.html

pgr_bddijkstracost(text, bigint, bigint, directed boolean DEFAULT true, OUT start_vid bigint, OUT end_vid bigint, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_bdDijkstraCost(One to One)

Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- From vertex identifier
- To vertex identifier
Optional Parameters
- directed := true
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_bdDijkstraCost.html

pgr_bddijkstracost(text, bigint, anyarray, directed boolean DEFAULT true, OUT start_vid bigint, OUT end_vid bigint, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_bdDijkstraCost(One to Many)

Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- From vertex identifier
- To ARRAY[vertices identifiers]
Optional Parameters
- directed := true
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_bdDijkstraCost.html

pgr_bddijkstracost(text, anyarray, bigint, directed boolean DEFAULT true, OUT start_vid bigint, OUT end_vid bigint, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_bdDijkstraCost(Many to One)

Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- From ARRAY[vertices identifiers]
- To vertex identifier
Optional Parameters
- directed := true
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_bdDijkstraCost.html

pgr_bddijkstracost(text, anyarray, anyarray, directed boolean DEFAULT true, OUT start_vid bigint, OUT end_vid bigint, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_bdDijkstraCost(Many to Many)

Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- From ARRAY[vertices identifiers]
- To ARRAY[vertices identifiers]
Optional Parameters
- directed := true
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_bdDijkstraCost.html

pgr_bddijkstracost(text, text, directed boolean DEFAULT true, OUT start_vid bigint, OUT end_vid bigint, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_bdDijkstraCost(Combinations)

Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- Combinations SQL with columns: source, target
Optional Parameters
- directed := true
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_bdDijkstraCost.html

pgr_bddijkstracostmatrix(text, anyarray, directed boolean DEFAULT true, OUT start_vid bigint, OUT end_vid bigint, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_bdDijkstraCostMatrix

Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- ARRAY [vertices identifiers]
Optional Parameters
- directed := true
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_bdDijkstraCostMatrix.html

pgr_bellmanford(text, bigint, bigint, directed boolean DEFAULT true, OUT seq integer, OUT path_seq integer, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_bellmanFord(One to One)

EXPERIMENTAL
Parameters:
- edges SQL with columns: id, source, target, cost [,reverse_cost]
- From vertex identifier
- To vertex identifier
Optional Parameters:
- directed := true
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_bellmanFord.html

pgr_bellmanford(text, bigint, anyarray, directed boolean DEFAULT true, OUT seq integer, OUT path_seq integer, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_bellmanFord(One to Many)

EXPERIMENTAL
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- From vertex identifier
- To ARRAY[vertices identifiers]
Optional Parameters
- directed := true
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_bellmanFord.html

pgr_bellmanford(text, anyarray, bigint, directed boolean DEFAULT true, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_bellmanFord(Many to One)

EXPERIMENTAL
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- From ARRAY[vertices identifiers]
- To vertex identifier
Optional Parameters
- directed := true
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_bellmanFord.html

pgr_bellmanford(text, anyarray, anyarray, directed boolean DEFAULT true, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_bellmanFord(Many to Many)

EXPERIMENTAL
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- From ARRAY[vertices identifiers]
- To ARRAY[vertices identifiers]
Optional Parameters
- directed := true
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_bellmanFord.html

pgr_bellmanford(text, text, directed boolean DEFAULT true, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_bellmanFord(Combinations)

EXPERIMENTAL
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- Combinations SQL with columns: source, target
Optional Parameters
- directed := true
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_bellmanFord.html

pgr_biconnectedcomponents(text, OUT seq bigint, OUT component bigint, OUT edge bigint)

Returns: SETOF record
Language: sql
Kind: function

pgr_biconnectedComponents

Undirected graph
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_biconnectedComponents.html

pgr_binarybreadthfirstsearch(text, bigint, bigint, directed boolean DEFAULT true, OUT seq integer, OUT path_seq integer, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_binaryBreadthFirstSearch(One to One)

EXPERIMENTAL
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- From vertex identifier
- To vertex identifier
Optional Parameters
- directed := true
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_binaryBreadthFirstSearch.html

pgr_binarybreadthfirstsearch(text, bigint, anyarray, directed boolean DEFAULT true, OUT seq integer, OUT path_seq integer, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_binaryBreadthFirstSearch(One to Many)

EXPERIMENTAL
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- From vertex identifier
- To ARRAY[vertices identifiers]
Optional Parameters
- directed := true
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_binaryBreadthFirstSearch.html

pgr_binarybreadthfirstsearch(text, anyarray, bigint, directed boolean DEFAULT true, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_binaryBreadthFirstSearch(Many to One)

EXPERIMENTAL
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- From ARRAY[vertices identifiers]
- To vertex identifier
Optional Parameters
- directed := true
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_binaryBreadthFirstSearch.html

pgr_binarybreadthfirstsearch(text, anyarray, anyarray, directed boolean DEFAULT true, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_binaryBreadthFirstSearch(Many to Many)

EXPERIMENTAL
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- From ARRAY[vertices identifiers]
- To ARRAY[vertices identifiers]
Optional Parameters
- directed := true
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_binaryBreadthFirstSearch.html

pgr_binarybreadthfirstsearch(text, text, directed boolean DEFAULT true, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_binaryBreadthFirstSearch(Combinations)

EXPERIMENTAL
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- Combinations SQL with columns: source, target
Optional Parameters
- directed := true
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_binaryBreadthFirstSearch.html

pgr_bipartite(text, OUT vertex_id bigint, OUT color_id bigint)

Returns: SETOF record
Language: plpgsql
Kind: function

pgr_bipartite

EXPERIMENTAL
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_bipartite.html

pgr_boykovkolmogorov(text, bigint, bigint, OUT seq integer, OUT edge bigint, OUT start_vid bigint, OUT end_vid bigint, OUT flow bigint, OUT residual_capacity bigint)

Returns: SETOF record
Language: sql
Kind: function

pgr_boykovKolmogorov(One to One)

Directed graph
Parameters:
- edges SQL with columns: id, source, target, capacity [,reverse_capacity]
- from vertex
- to vertex
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_boykovKolmogorov.html

pgr_boykovkolmogorov(text, bigint, anyarray, OUT seq integer, OUT edge bigint, OUT start_vid bigint, OUT end_vid bigint, OUT flow bigint, OUT residual_capacity bigint)

Returns: SETOF record
Language: sql
Kind: function

pgr_boykovKolmogorov(One to Many)

Directed graph
Parameters:
- edges SQL with columns: id, source, target, capacity [,reverse_capacity]
- from vertex
- to ARRAY[vertices identifiers]
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_boykovKolmogorov.html

pgr_boykovkolmogorov(text, anyarray, bigint, OUT seq integer, OUT edge bigint, OUT start_vid bigint, OUT end_vid bigint, OUT flow bigint, OUT residual_capacity bigint)

Returns: SETOF record
Language: sql
Kind: function

pgr_boykovKolmogorov(Many to One)

Directed graph
Parameters:
- edges SQL with columns: id, source, target, capacity [,reverse_capacity]
- from ARRAY[vertices identifiers]
- to vertex
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_boykovKolmogorov.html

pgr_boykovkolmogorov(text, anyarray, anyarray, OUT seq integer, OUT edge bigint, OUT start_vid bigint, OUT end_vid bigint, OUT flow bigint, OUT residual_capacity bigint)

Returns: SETOF record
Language: sql
Kind: function

pgr_boykovKolmogorov(Many to Many)

Directed graph
Parameters:
- edges SQL with columns: id, source, target, capacity [,reverse_capacity]
- from ARRAY[vertices identifiers]
- to ARRAY[vertices identifiers]
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_boykovKolmogorov.html

pgr_boykovkolmogorov(text, text, OUT seq integer, OUT edge bigint, OUT start_vid bigint, OUT end_vid bigint, OUT flow bigint, OUT residual_capacity bigint)

Returns: SETOF record
Language: sql
Kind: function

pgr_boykovKolmogorov(Combinations)

Directed graph
Parameters:
- Edges SQL with columns: id, source, target, capacity [,reverse_capacity]
- Combinations SQL with columns: source, target
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_boykovKolmogorov.html

pgr_breadthfirstsearch(text, bigint, max_depth bigint DEFAULT '9223372036854775807'::bigint, directed boolean DEFAULT true, OUT seq bigint, OUT depth bigint, OUT start_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: plpgsql
Kind: function

pgr_breadthFirstSearch(One to Depth)

EXPERIMENTAL
Parameters:
- edges SQL with columns: id, source, target, cost [,reverse_cost]
- From vertex identifier
Optional Parameters:
- Maximum Depth := 9223372036854775807
- directed := true
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_breadthFirstSearch.html

pgr_breadthfirstsearch(text, anyarray, max_depth bigint DEFAULT '9223372036854775807'::bigint, directed boolean DEFAULT true, OUT seq bigint, OUT depth bigint, OUT start_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: plpgsql
Kind: function

pgr_breadthFirstSearch(Many to Depth)

EXPERIMENTAL
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- From ARRAY[vertices identifiers]
Optional Parameters
- Maximum Depth := 9223372036854775807
- directed := true
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_breadthFirstSearch.html

pgr_bridges(text, OUT edge bigint)

Returns: SETOF bigint
Language: sql
Kind: function

pgr_bridges

Undirected graph
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_bridges.html

pgr_chinesepostman(text, OUT seq integer, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_chinesePostman

EXPERIMENTAL
Directed graph
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_chinesePostman.html

pgr_chinesepostmancost(text)

Returns: double precision
Language: sql
Kind: function

pgr_chinesePostmanCost

EXPERIMENTAL
Directed graph
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_chinesePostmanCost.html

pgr_connectedcomponents(text, OUT seq bigint, OUT component bigint, OUT node bigint)

Returns: SETOF record
Language: sql
Kind: function

pgr_connectedComponents

Undirected graph
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_connectedComponents.html

pgr_contraction(text, bigint[], max_cycles integer DEFAULT 1, forbidden_vertices bigint[] DEFAULT ARRAY[]::bigint[], directed boolean DEFAULT true, OUT type text, OUT id bigint, OUT contracted_vertices bigint[], OUT source bigint, OUT target bigint, OUT cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_contraction

Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- ARRAY [Contraction order]
Optional Parameters
- max_cycles := 1
- forbidden_vertices := ARRAY[]::BIGINT[]
- directed := true
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_contraction.html

pgr_createtopology(text, double precision, the_geom text DEFAULT 'the_geom'::text, id text DEFAULT 'id'::text, source text DEFAULT 'source'::text, target text DEFAULT 'target'::text, rows_where text DEFAULT 'true'::text, clean boolean DEFAULT false)

Returns: character varying
Language: plpgsql
Kind: function

pgr_createTopology

Parameters
- Edge table name
- tolerance
Optional parameters
- the_geom := 'the_geom'
- id := 'id'
- source := 'source'
- target := 'target'
- rows_where := 'true'
- clean := false
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_createTopology.html

pgr_createverticestable(text, the_geom text DEFAULT 'the_geom'::text, source text DEFAULT 'source'::text, target text DEFAULT 'target'::text, rows_where text DEFAULT 'true'::text)

Returns: text
Language: plpgsql
Kind: function

pgr_createVerticesTable

Parameters
- Edge table name
Optional parameters
- the_geom := 'the_geom'
- source := 'source'
- target := 'target'
- rows_where := 'true'
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_createVerticesTable.html

pgr_cuthillmckeeordering(text, OUT seq bigint, OUT node bigint)

Returns: SETOF record
Language: sql
Kind: function

pgr_cuthillMckeeOrdering

EXPERIMENTAL
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_cuthillMckeeOrdering.html

pgr_dagshortestpath(text, bigint, bigint, OUT seq integer, OUT path_seq integer, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_dagShortestPath(One to One)

EXPERIMENTAL
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- From vertex identifier
- To vertex identifier
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_dagShortestPath.html

pgr_dagshortestpath(text, bigint, anyarray, OUT seq integer, OUT path_seq integer, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_dagShortestPath(One to Many)

EXPERIMENTAL
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- From vertex identifier
- To ARRAY[vertices identifiers]
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_dagShortestPath.html

pgr_dagshortestpath(text, anyarray, bigint, OUT seq integer, OUT path_seq integer, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_dagShortestPath(Many to One)

EXPERIMENTAL
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- From ARRAY[vertices identifiers]
- To vertex identifier
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_dagShortestPath.html

pgr_dagshortestpath(text, anyarray, anyarray, OUT seq integer, OUT path_seq integer, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_dagShortestPath(Many to Many)

EXPERIMENTAL
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- From ARRAY[vertices identifiers]
- To ARRAY[vertices identifiers]
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_dagShortestPath.html

pgr_dagshortestpath(text, text, OUT seq integer, OUT path_seq integer, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_dagShortestPath(Combinations)

EXPERIMENTAL
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- Combinations SQL with columns: source, target
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_dagShortestPath.html

pgr_degree(text, text, dryrun boolean DEFAULT false, OUT node bigint, OUT degree bigint)

Returns: SETOF record
Language: plpgsql
Kind: function

pgr_degree

PROPOSED
Parameters
Edges SQL with columns: id
Vertices SQL with columns: id, in_edges, out_edges
Documentation:
https://docs.pgrouting.org/latest/en/pgr_degree.html

pgr_depthfirstsearch(text, bigint, directed boolean DEFAULT true, max_depth bigint DEFAULT '9223372036854775807'::bigint, OUT seq bigint, OUT depth bigint, OUT start_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: plpgsql
Kind: function

pgr_depthFirstSearch(Single Vertex)

PROPOSED
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- From root vertex identifier
Optional parameters
- directed := true
- max_depth := 9223372036854775807
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_depthFirstSearch.html

pgr_depthfirstsearch(text, anyarray, directed boolean DEFAULT true, max_depth bigint DEFAULT '9223372036854775807'::bigint, OUT seq bigint, OUT depth bigint, OUT start_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: plpgsql
Kind: function

pgr_depthFirstSearch(Multiple Vertices)

PROPOSED
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- From ARRAY[root vertices identifiers]
Optional parameters
- directed := true
- max_depth := 9223372036854775807
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_depthFirstSearch.html

pgr_dijkstra(text, bigint, bigint, directed boolean DEFAULT true, OUT seq integer, OUT path_seq integer, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_dijkstra(One to One)

Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- From vertex identifier
- To vertex identifier
Optional Parameters
- directed := true
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_dijkstra.html

pgr_dijkstra(text, bigint, anyarray, directed boolean DEFAULT true, OUT seq integer, OUT path_seq integer, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_dijkstra(One to Many)

Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- From vertex identifier
- To ARRAY[vertices identifiers]
Optional Parameters
- directed := true
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_dijkstra.html

pgr_dijkstra(text, anyarray, bigint, directed boolean DEFAULT true, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_dijkstra(Many to One)

Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- From ARRAY[vertices identifiers]
- To vertex identifier
Optional Parameters
- directed := true
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_dijkstra.html

pgr_dijkstra(text, anyarray, anyarray, directed boolean DEFAULT true, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_dijkstra(Many to Many)

Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- From ARRAY[vertices identifiers]
- To ARRAY[vertices identifiers]
Optional Parameters
- directed := true
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_dijkstra.html

pgr_dijkstra(text, text, directed boolean DEFAULT true, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_dijkstra(Combinations)

Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- Combinations SQL with columns: source, target
Optional Parameters
- directed := true
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_dijkstra.html

pgr_dijkstracost(text, bigint, bigint, directed boolean DEFAULT true, OUT start_vid bigint, OUT end_vid bigint, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_dijkstraCost(One to One)

Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- From vertex identifier
- To vertex identifier
Optional Parameters
- directed := true
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_dijkstraCost.html

pgr_dijkstracost(text, bigint, anyarray, directed boolean DEFAULT true, OUT start_vid bigint, OUT end_vid bigint, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_dijkstraCost(One to Many)

Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- From vertex identifier
- To ARRAY[vertices identifiers]
Optional Parameters
- directed := true
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_dijkstraCost.html

pgr_dijkstracost(text, anyarray, bigint, directed boolean DEFAULT true, OUT start_vid bigint, OUT end_vid bigint, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_dijkstraCost(Many to One)

Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- From ARRAY[vertices identifiers]
- To vertex identifier
Optional Parameters
- directed := true
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_dijkstraCost.html

pgr_dijkstracost(text, anyarray, anyarray, directed boolean DEFAULT true, OUT start_vid bigint, OUT end_vid bigint, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_dijkstraCost(Many to Many)

Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- From ARRAY[vertices identifiers]
- To ARRAY[vertices identifiers]
Optional Parameters
- directed := true
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_dijkstraCost.html

pgr_dijkstracost(text, text, directed boolean DEFAULT true, OUT start_vid bigint, OUT end_vid bigint, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_dijkstraCost(Combinations SQL)

Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- Combinations SQL with columns: source, target
Optional Parameters
- directed := true
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_dijkstraCost.html

pgr_dijkstracostmatrix(text, anyarray, directed boolean DEFAULT true, OUT start_vid bigint, OUT end_vid bigint, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_dijkstraCostMatrix

Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- ARRAY [vertices identifiers]
Optional Parameters
- directed := true
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_dijkstraCostMatrix.html

pgr_dijkstranear(text, bigint, anyarray, directed boolean DEFAULT true, cap bigint DEFAULT 1, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_dijkstraNear(One to Many)

PROPOSED
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- From vertex identifier
- To ARRAY[vertices identifiers]
Optional Parameters
- directed => true
- cap => 1 (nth found)
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_dijkstraNear.html

pgr_dijkstranear(text, anyarray, bigint, directed boolean DEFAULT true, cap bigint DEFAULT 1, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_dijkstraNear(Many to One)

PROPOSED
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- From ARRAY[vertices identifiers]
- To vertex identifier
Optional Parameters
- directed => true
- cap => 1 (nth found)
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_dijkstraNear.html

pgr_dijkstranear(text, anyarray, anyarray, directed boolean DEFAULT true, cap bigint DEFAULT 1, global boolean DEFAULT true, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_dijkstraNear(Many to Many)

PROPOSED
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- From ARRAY[vertices identifiers]
- To ARRAY[vertices identifiers]
Optional Parameters
- directed => true
- cap => 1 (nth found)
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_dijkstraNear.html

pgr_dijkstranear(text, text, directed boolean DEFAULT true, cap bigint DEFAULT 1, global boolean DEFAULT true, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_dijkstraNear(Combinations)

PROPOSED
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- Combinations SQL with columns: source, target
Optional Parameters
- directed => true
- cap => 1 (nth found)
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_dijkstraNear.html

pgr_dijkstranearcost(text, bigint, anyarray, directed boolean DEFAULT true, cap bigint DEFAULT 1, OUT start_vid bigint, OUT end_vid bigint, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_dijkstraNearCost(One to Many)

PROPOSED
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- From vertex identifier
- To ARRAY[vertices identifiers]
Optional Parameters
- directed => true
- cap => 1 (nth found)
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_dijkstraNearCost.html

pgr_dijkstranearcost(text, anyarray, bigint, directed boolean DEFAULT true, cap bigint DEFAULT 1, OUT start_vid bigint, OUT end_vid bigint, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_dijkstraNearCost(Many to One)

PROPOSED
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- From ARRAY[vertices identifiers]
- To vertex identifier
Optional Parameters
- directed => true
- cap => 1 (nth found)
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_dijkstraNearCost.html

pgr_dijkstranearcost(text, anyarray, anyarray, directed boolean DEFAULT true, cap bigint DEFAULT 1, global boolean DEFAULT true, OUT start_vid bigint, OUT end_vid bigint, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_dijkstraNearCost(Many to Many)

PROPOSED
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- From ARRAY[vertices identifiers]
- To ARRAY[vertices identifiers]
Optional Parameters
- directed => true
- cap => 1 (nth found)
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_dijkstraNearCost.html

pgr_dijkstranearcost(text, text, directed boolean DEFAULT true, cap bigint DEFAULT 1, global boolean DEFAULT true, OUT start_vid bigint, OUT end_vid bigint, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_dijkstraNearCost(Combinations)

PROPOSED
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- Combinations SQL with columns: source, target
Optional Parameters
- directed => true
- cap => 1 (nth found)
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_dijkstraNearCost.html

pgr_dijkstravia(text, anyarray, directed boolean DEFAULT true, strict boolean DEFAULT false, u_turn_on_edge boolean DEFAULT true, OUT seq integer, OUT path_id integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision, OUT route_agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_dijkstraVia

PROPOSED
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- ARRAY[via vertices identifiers]
Optional Parameters
- directed := true
- strict := false
- U_turn_on_edge := true
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_dijkstraVia.html

pgr_drivingdistance(text, anyarray, double precision, directed boolean DEFAULT true, equicost boolean DEFAULT false, OUT seq integer, OUT from_v bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_drivingDistance(Multiple vertices)

Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- From ARRAY[vertices identifiers]
- Distance from vertices identifiers
Optional Parameters
- directed := true
- equicost := false
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_drivingDistance.html

pgr_drivingdistance(text, bigint, double precision, directed boolean DEFAULT true, OUT seq integer, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_drivingDistance(Single_vertex)

Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- From vertex identifier
- Distance from vertex identifier
Optional Parameters
- directed := true
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_drivingDistance.html

pgr_edgecoloring(text, OUT edge_id bigint, OUT color_id bigint)

Returns: SETOF record
Language: plpgsql
Kind: function

pgr_edgeColoring

EXPERIMENTAL
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_edgeColoring.html

pgr_edgedisjointpaths(text, bigint, bigint, directed boolean DEFAULT true, OUT seq integer, OUT path_id integer, OUT path_seq integer, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_edgeDisjointPaths(One to One)

Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- From vertex identifier
- to vertex identifier
Optional Parameters
- directed := true
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_edgeDisjointPaths.html

pgr_edgedisjointpaths(text, bigint, anyarray, directed boolean DEFAULT true, OUT seq integer, OUT path_id integer, OUT path_seq integer, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_edgeDisjointPaths(One to Many)

Parameters:
- dges SQL with columns: id, source, target, cost [,reverse_cost]
- From vertex identifier
- to ARRAY[vertices identifiers]
Optional Parameters
- directed := true
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_edgeDisjointPaths.html

pgr_edgedisjointpaths(text, anyarray, bigint, directed boolean DEFAULT true, OUT seq integer, OUT path_id integer, OUT path_seq integer, OUT start_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_edgeDisjointPaths(Many to One)

Parameters:
- edges SQL with columns: id, source, target, cost [,reverse_cost]
- From ARRAY[vertices identifiers]
- to vertex identifier
Optional Parameters
- directed := true
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_edgeDisjointPaths.html

pgr_edgedisjointpaths(text, anyarray, anyarray, directed boolean DEFAULT true, OUT seq integer, OUT path_id integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_edgeDisjointPaths(Many to Many)

Parameters:
- edges SQL with columns: id, source, target, cost [,reverse_cost]
- From ARRAY[vertices identifiers]
- to ARRAY[vertices identifiers]
Optional Parameters
- directed := true
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_edgeDisjointPaths.html

pgr_edgedisjointpaths(text, text, directed boolean DEFAULT true, OUT seq integer, OUT path_id integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_edgeDisjointPaths(Combinations)

Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- Combinations SQL with columns: source, target
Optional Parameters
- directed := true
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_edgeDisjointPaths.html

pgr_edmondskarp(text, bigint, bigint, OUT seq integer, OUT edge bigint, OUT start_vid bigint, OUT end_vid bigint, OUT flow bigint, OUT residual_capacity bigint)

Returns: SETOF record
Language: sql
Kind: function

pgr_edmondsKarp(One to One)

Directed graph
Parameters:
- Edges SQL with columns: id, source, target, capacity [,reverse_capacity]
- From vertex
- to vertex
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_edmondsKarp.html

pgr_edmondskarp(text, bigint, anyarray, OUT seq integer, OUT edge bigint, OUT start_vid bigint, OUT end_vid bigint, OUT flow bigint, OUT residual_capacity bigint)

Returns: SETOF record
Language: sql
Kind: function

pgr_edmondsKarp(One to Many)

Directed graph
Parameters:
- Edges SQL with columns: id, source, target, capacity [,reverse_capacity]
- From vertex
- to ARRAY[vertices identifiers]
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_edmondsKarp.html

pgr_edmondskarp(text, anyarray, bigint, OUT seq integer, OUT edge bigint, OUT start_vid bigint, OUT end_vid bigint, OUT flow bigint, OUT residual_capacity bigint)

Returns: SETOF record
Language: sql
Kind: function

pgr_edmondsKarp(Many to One)

Directed graph
Parameters:
- Edges SQL with columns: id, source, target, capacity [,reverse_capacity]
- From ARRAY[vertices identifiers]
- to vertex
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_edmondsKarp.html

pgr_edmondskarp(text, anyarray, anyarray, OUT seq integer, OUT edge bigint, OUT start_vid bigint, OUT end_vid bigint, OUT flow bigint, OUT residual_capacity bigint)

Returns: SETOF record
Language: sql
Kind: function

pgr_edmondsKarp(Many to Many)

Directed graph
Parameters:
- Edges SQL with columns: id, source, target, capacity [,reverse_capacity]
- From ARRAY[vertices identifiers]
- to ARRAY[vertices identifiers]
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_edmondsKarp.html

pgr_edmondskarp(text, text, OUT seq integer, OUT edge bigint, OUT start_vid bigint, OUT end_vid bigint, OUT flow bigint, OUT residual_capacity bigint)

Returns: SETOF record
Language: sql
Kind: function

pgr_edmondsKarp(Combinations)

Directed graph
Parameters:
- Edges SQL with columns: id, source, target, capacity [,reverse_capacity]
- Combinations SQL with columns: source, target
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_edmondsKarp.html

pgr_edwardmoore(text, bigint, bigint, directed boolean DEFAULT true, OUT seq integer, OUT path_seq integer, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_edwardMoore(One to One)

EXPERIMENTAL
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- From vertex identifier
- To vertex identifier
Optional Parameters
- directed := true
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_edwardMoore.html

pgr_edwardmoore(text, bigint, anyarray, directed boolean DEFAULT true, OUT seq integer, OUT path_seq integer, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_edwardMoore(One to Many)

EXPERIMENTAL
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- From vertex identifier
- To ARRAY[vertices identifiers]
Optional Parameters
- directed := true
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_edwardMoore.html

pgr_edwardmoore(text, anyarray, bigint, directed boolean DEFAULT true, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_edwardMoore(Many to One)

EXPERIMENTAL
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- From ARRAY[vertices identifiers]
- To vertex identifier
Optional Parameters
- directed := true
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_edwardMoore.html

pgr_edwardmoore(text, anyarray, anyarray, directed boolean DEFAULT true, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_edwardMoore(Many to Many)

EXPERIMENTAL
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- From ARRAY[vertices identifiers]
- To ARRAY[vertices identifiers]
Optional Parameters
- directed := true
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_edwardMoore.html

pgr_edwardmoore(text, text, directed boolean DEFAULT true, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_edwardMoore(Combinations)

EXPERIMENTAL
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- Combinations SQL with columns: source, target
Optional Parameters
- directed := true
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_edwardMoore.html

pgr_extractvertices(text, dryrun boolean DEFAULT false, OUT id bigint, OUT in_edges bigint[], OUT out_edges bigint[], OUT x double precision, OUT y double precision, OUT geom gis.geometry)

Returns: SETOF record
Language: plpgsql
Kind: function

pgr_extractVertices

PROPOSED
Parameters
- Edges SQL with columns: [id,] startpoint, endpoint OR
- Edges SQL with columns: [id,] source, target OR
- Edges SQL with columns: [id,] geom
Documentation:
https://docs.pgrouting.org/latest/en/pgr_extractVertices.html

pgr_findcloseedges(text, gis.geometry, double precision, cap integer DEFAULT 1, partial boolean DEFAULT true, dryrun boolean DEFAULT false, OUT edge_id bigint, OUT fraction double precision, OUT side character, OUT distance double precision, OUT geom gis.geometry, OUT edge gis.geometry)

Returns: SETOF record
Language: plpgsql
Kind: function

pgr_findCloseEdges(Many Points)

Parameters:
- Edges SQL with columns: id, geom
- Array of POINT geometries
- Maximum separation between geometries
Optional Parameters
- cap => 1: at most one answer
- partial => true: do minimal calculations
- dryrun => false: do not output code
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_findCloseEdges.html

pgr_findcloseedges(text, gis.geometry[], double precision, cap integer DEFAULT 1, partial boolean DEFAULT true, dryrun boolean DEFAULT false, OUT edge_id bigint, OUT fraction double precision, OUT side character, OUT distance double precision, OUT geom gis.geometry, OUT edge gis.geometry)

Returns: SETOF record
Language: plpgsql
Kind: function

pgr_floydwarshall(text, directed boolean DEFAULT true, OUT start_vid bigint, OUT end_vid bigint, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_floydWarshall

Parameters:
- edges SQL with columns: source, target, cost [,reverse_cost])
Optional Parameters:
- directed := true
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_floydWarshall.html

pgr_full_version(OUT version text, OUT build_type text, OUT compile_date text, OUT library text, OUT system text, OUT postgresql text, OUT compiler text, OUT boost text, OUT hash text)

Returns: record
Language: sql
Kind: function

pgr_full_version

Documentation
- https://docs.pgrouting.org/latest/en/pgr_full_version.html

pgr_hawickcircuits(text, OUT seq integer, OUT path_id integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: plpgsql
Kind: function

pgr_hawickCircuits

EXPERIMENTAL
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_hawickCircuits.html

pgr_isplanar(text)

Returns: boolean
Language: sql
Kind: function

pgr_isPlanar

EXPERIMENTAL
Undirected graph
Parameters:
- edges SQL with columns: id, source, target, cost [,reverse_cost]
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_isPlanar.html

pgr_johnson(text, directed boolean DEFAULT true, OUT start_vid bigint, OUT end_vid bigint, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_johnson

Parameters:
- edges SQL with columns: source, target, cost [,reverse_cost])
Optional Parameters:
- directed := true
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_johnson.html

pgr_kruskal(text, OUT edge bigint, OUT cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_kruskal

Undirected graph
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_kruskal.html

pgr_kruskalbfs(text, bigint, max_depth bigint DEFAULT '9223372036854775807'::bigint, OUT seq bigint, OUT depth bigint, OUT start_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: plpgsql
Kind: function

pgr_kruskalBFS(Single Vertex)

Undirected graph
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- From root vertex identifier
Optional parameters
- max_depth: default := 9223372036854775807
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_kruskalBFS.html

pgr_kruskalbfs(text, anyarray, max_depth bigint DEFAULT '9223372036854775807'::bigint, OUT seq bigint, OUT depth bigint, OUT start_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: plpgsql
Kind: function

pgr_kruskalBFS(multiple Vertices)

Undirected graph
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- From ARRAY[root vertices identifiers]
Optional parameters
- max_depth: default := 9223372036854775807
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_kruskalBFS.html

pgr_kruskaldd(text, bigint, numeric, OUT seq bigint, OUT depth bigint, OUT start_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: plpgsql
Kind: function

pgr_kruskalDD(Single Vertex)

Undirected graph
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- From root vertex identifier
- Distance
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_kruskalDD.html

pgr_kruskaldd(text, bigint, double precision, OUT seq bigint, OUT depth bigint, OUT start_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: plpgsql
Kind: function

pgr_kruskalDD(Single Vertex)

Undirected graph
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- From root vertex identifier
- Distance
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_kruskalDD.html

pgr_kruskaldd(text, anyarray, numeric, OUT seq bigint, OUT depth bigint, OUT start_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: plpgsql
Kind: function

pgr_kruskalDD(Multiple Vertices)

Undirected graph
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- From ARRAY[root vertices identifiers]
- Distance
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_kruskalDD.html

pgr_kruskaldd(text, anyarray, double precision, OUT seq bigint, OUT depth bigint, OUT start_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: plpgsql
Kind: function

pgr_kruskalDD(Multiple Vertices)

Undirected graph
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- From ARRAY[root vertices identifiers]
- Distance
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_kruskalDD.html

pgr_kruskaldfs(text, bigint, max_depth bigint DEFAULT '9223372036854775807'::bigint, OUT seq bigint, OUT depth bigint, OUT start_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: plpgsql
Kind: function

pgr_kruskalDFS(Single Vertex)

Undirected graph
Parameters:
- edges SQL with columns: id, source, target, cost [,reverse_cost]
- from root vertex identifier
Optional parameters
- max_depth: default 9223372036854775807
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_kruskalDFS.html

pgr_kruskaldfs(text, anyarray, max_depth bigint DEFAULT '9223372036854775807'::bigint, OUT seq bigint, OUT depth bigint, OUT start_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: plpgsql
Kind: function

pgr_kruskalDFS(Multiple Vertices)

Undirected graph
Parameters:
- edges SQL with columns: id, source, target, cost [,reverse_cost]
- from ARRAY[root vertices identifiers]
Optional parameters
- max_depth: default 9223372036854775807
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_kruskalDFS.html

pgr_ksp(text, bigint, bigint, integer, directed boolean DEFAULT true, heap_paths boolean DEFAULT false, OUT seq integer, OUT path_id integer, OUT path_seq integer, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_KSP

Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- From vertex identifier
- To vertex identifier
- K
Optional Parameters
- directed := true
- heap_paths := false
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_KSP.html

pgr_lengauertarjandominatortree(text, bigint, OUT seq integer, OUT vertex_id bigint, OUT idom bigint)

Returns: SETOF record
Language: plpgsql
Kind: function

pgr_lengauerTarjanDominatorTree

EXPERIMENTAL
Directed graph
Parameters:
- edges SQL with columns: id, source, target, cost [,reverse_cost]
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_lengauerTarjanDominatorTree.html

pgr_linegraph(text, directed boolean DEFAULT true, OUT seq integer, OUT source bigint, OUT target bigint, OUT cost double precision, OUT reverse_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_lineGraph

EXPERIMENTAL
Parameters:
- edges SQL with columns: id, source, target, cost [,reverse_cost]
Optional Parameters:
- directed := true
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_lineGraph.html

pgr_linegraphfull(text, OUT seq integer, OUT source bigint, OUT target bigint, OUT cost double precision, OUT edge bigint)

Returns: SETOF record
Language: sql
Kind: function

pgr_lineGraphFull

EXPERIMENTAL
For Directed Graph
Parameters:
- edges SQL with columns: id, source, target, cost [,reverse_cost]
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_lineGraphFull.html

pgr_makeconnected(text, OUT seq bigint, OUT start_vid bigint, OUT end_vid bigint)

Returns: SETOF record
Language: sql
Kind: function

pgr_makeConnected

EXPERIMENTAL
Undirected graph
Parameters:
- edges SQL with columns: id, source, target, cost [,reverse_cost]
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_makeConnected.html

pgr_maxcardinalitymatch(text, OUT edge bigint)

Returns: SETOF bigint
Language: sql
Kind: function

pgr_maxCardinalityMatch

Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
Documentation:
https://docs.pgrouting.org/latest/en/pgr_maxCardinalityMatch.html

pgr_maxcardinalitymatch(text, directed boolean, OUT seq integer, OUT edge bigint, OUT source bigint, OUT target bigint)

Returns: SETOF record
Language: plpgsql
Kind: function

pgr_maxCardinalityMatch

DEPRECATED signature on v3.4.0
Use without boolean paramater
Regardless of boolen value it will work for undirected graphs
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_maxCardinalityMatch.html

pgr_maxflow(text, bigint, bigint)

Returns: bigint
Language: sql
Kind: function

pgr_maxFlow(One to One)

Directed graph
Parameters:
- edges SQL with columns: id, source, target, capacity [,reverse_capacity]
- from vertex
- to vertex
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_maxFlow.html

pgr_maxflow(text, bigint, anyarray)

Returns: bigint
Language: sql
Kind: function

pgr_maxFlow(One to Many)

Directed graph
Parameters:
- edges SQL with columns: id, source, target, capacity [,reverse_capacity]
- from vertex
- to ARRAY[vertices identifiers]
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_maxFlow.html

pgr_maxflow(text, anyarray, bigint)

Returns: bigint
Language: sql
Kind: function

pgr_maxFlow(Many to One)

Directed graph
Parameters:
- edges SQL with columns: id, source, target, capacity [,reverse_capacity]
- from ARRAY[vertices identifiers]
- to vertex
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_maxFlow.html

pgr_maxflow(text, anyarray, anyarray)

Returns: bigint
Language: sql
Kind: function

pgr_maxFlow(Many to Many)

Directed graph
Parameters:
- edges SQL with columns: id, source, target, capacity [,reverse_capacity]
- from ARRAY[vertices identifiers]
- to ARRAY[vertices identifiers]
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_maxFlow.html

pgr_maxflow(text, text)

Returns: bigint
Language: sql
Kind: function

pgr_maxFlow(Combinations)

Directed graph
Parameters:
- Edges SQL with columns: id, source, target, capacity [,reverse_capacity]
- Combinations SQL with columns: source, target
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_maxFlow.html

pgr_maxflowmincost(text, bigint, bigint, OUT seq integer, OUT edge bigint, OUT source bigint, OUT target bigint, OUT flow bigint, OUT residual_capacity bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_maxFlowMinCost(One to One)

EXPERIMENTAL
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- From vertex identifier
- To vertex identifier
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_maxFlowMinCost.html

pgr_maxflowmincost(text, bigint, anyarray, OUT seq integer, OUT edge bigint, OUT source bigint, OUT target bigint, OUT flow bigint, OUT residual_capacity bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_maxFlowMinCost(One to Many)

EXPERIMENTAL
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- From vertex identifier
- To ARRAY[vertices identifiers]
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_maxFlowMinCost.html

pgr_maxflowmincost(text, anyarray, bigint, OUT seq integer, OUT edge bigint, OUT source bigint, OUT target bigint, OUT flow bigint, OUT residual_capacity bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_maxFlowMinCost(Many to One)

EXPERIMENTAL
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- From ARRAY[vertices identifiers]vertex identifier
- To vertex identifier
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_maxFlowMinCost.html

pgr_maxflowmincost(text, anyarray, anyarray, OUT seq integer, OUT edge bigint, OUT source bigint, OUT target bigint, OUT flow bigint, OUT residual_capacity bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

EXPERIMENTAL pgr_maxFlowMinCost(Many to Many)

EXPERIMENTAL
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- From ARRAY[vertices identifiers]
- To ARRAY[vertices identifiers]
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_maxFlowMinCost.html

pgr_maxflowmincost(text, text, OUT seq integer, OUT edge bigint, OUT source bigint, OUT target bigint, OUT flow bigint, OUT residual_capacity bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

EXPERIMENTAL pgr_maxFlowMinCost(Combinations)

EXPERIMENTAL
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- Combinations SQL with columns: source, target
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_maxFlowMinCost.html

pgr_maxflowmincost_cost(text, bigint, bigint)

Returns: double precision
Language: sql
Kind: function

pgr_maxFlowMinCost_Cost (One to One)

EXPERIMENTAL
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- From vertex identifier
- To vertex identifier
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_maxFlowMinCost_Cost.html

pgr_maxflowmincost_cost(text, bigint, anyarray)

Returns: double precision
Language: sql
Kind: function

pgr_maxFlowMinCost_Cost(One to Many)

EXPERIMENTAL
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- From vertex identifier
- To ARRAY[vertices identifiers]
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_maxFlowMinCost_Cost.html

pgr_maxflowmincost_cost(text, anyarray, bigint)

Returns: double precision
Language: sql
Kind: function

pgr_maxFlowMinCost_Cost (Many to One)

EXPERIMENTAL
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- From ARRAY[vertices identifiers]
- To vertex identifier
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_maxFlowMinCost_Cost.html

pgr_maxflowmincost_cost(text, anyarray, anyarray)

Returns: double precision
Language: sql
Kind: function

EXPERIMENTAL pgr_maxFlowMinCost_Cost (Many to Many)

EXPERIMENTAL
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- From ARRAY[vertices identifiers]
- To ARRAY[vertices identifiers]
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_maxFlowMinCost_Cost.html

pgr_maxflowmincost_cost(text, text)

Returns: double precision
Language: sql
Kind: function

EXPERIMENTAL pgr_maxFlowMinCost_Cost (Combinations)

EXPERIMENTAL
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- Combinations SQL with columns: source, target
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_maxFlowMinCost_Cost.html

pgr_nodenetwork(text, double precision, id text DEFAULT 'id'::text, the_geom text DEFAULT 'the_geom'::text, table_ending text DEFAULT 'noded'::text, rows_where text DEFAULT ''::text, outall boolean DEFAULT false)

Returns: text
Language: plpgsql
Kind: function

pgr_nodeNetwork

Parameters
- Edge table name
- tolerance
Optional parameters
- id := 'id'
- the_geom := 'the_geom'
- table_ending := 'noded'
- rows_where := ''
- outall := false
DOCUMENTATION:
- https://docs.pgrouting.org/latest/en/pgr_nodeNetwork.html

pgr_pickdeliver(text, text, text, factor double precision DEFAULT 1, max_cycles integer DEFAULT 10, initial_sol integer DEFAULT 4, OUT seq integer, OUT vehicle_seq integer, OUT vehicle_id bigint, OUT stop_seq integer, OUT stop_type integer, OUT stop_id bigint, OUT order_id bigint, OUT cargo double precision, OUT travel_time double precision, OUT arrival_time double precision, OUT wait_time double precision, OUT service_time double precision, OUT departure_time double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_pickDeliver

EXPERIMENTAL
Parameters:
- orders SQL with columns:
  - id, demand, p_node_id, p_open, p_close, d_node_id, d_open, d_close
  - optional columns:
    - p_service := 0
    - d_service := 0
- vehicles SQL with columns:
  - id, capacity, start_open, start_close
  - optional columns:
    - speed := 1
    - start_service := 0
    - end_open := start_open
    - end_close := start_close
    - end_service := 0
- Matrix
  - start_vid
  - end_vid
  - agg_cost
Optional Parameters:
- factor: default := 1
- max_cycles: default := 10
- initial_sol: default := 4
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_pickDeliver.html

pgr_pickdelivereuclidean(text, text, factor double precision DEFAULT 1, max_cycles integer DEFAULT 10, initial_sol integer DEFAULT 4, OUT seq integer, OUT vehicle_seq integer, OUT vehicle_id bigint, OUT stop_seq integer, OUT stop_type integer, OUT order_id bigint, OUT cargo double precision, OUT travel_time double precision, OUT arrival_time double precision, OUT wait_time double precision, OUT service_time double precision, OUT departure_time double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_pickDeliverEuclidean

EXPERIMENTAL
Parameters:
- orders SQL with columns:
  - id, demand, p_x, p_t, d_x, d_y, p_open, p_close, d_open, d_close
  - optional columns:
    - p_service := 0
    - d_service := 0
- vehicles SQL with columns:
  - id, start_x, start_y, capacity, start_open, start_close
  - optional columns:
    - speed := 1
    - start_service := 0
    - end_x := start_x
    - end_y := start_y
    - end_open := start_open
    - end_close := start_close
    - end_service := 0
Optional Parameters:
- factor: default := 1
- max_cycles: default := 10
- initial_sol: default := 4
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_pickDeliver.html

pgr_prim(text, OUT edge bigint, OUT cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_prim

Undirected graph
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_prim.html

pgr_primbfs(text, bigint, max_depth bigint DEFAULT '9223372036854775807'::bigint, OUT seq bigint, OUT depth bigint, OUT start_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: plpgsql
Kind: function

pgr_primBFS(Single Vertex)

Undirected graph
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- From root vertex identifier
Optional parameters
- max_depth := 9223372036854775807
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_primBFS.html

pgr_primbfs(text, anyarray, max_depth bigint DEFAULT '9223372036854775807'::bigint, OUT seq bigint, OUT depth bigint, OUT start_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: plpgsql
Kind: function

pgr_primBFS(multiple Vertices)

Undirected graph
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- From ARRAY[root vertices identifiers]
Optional parameters
- max_depth := 9223372036854775807
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_primBFS.html

pgr_primdd(text, bigint, numeric, OUT seq bigint, OUT depth bigint, OUT start_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: plpgsql
Kind: function

pgr_primDD(Single Vertex)

Undirected graph
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- From root vertex identifier
- Distance
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_primDD.html

pgr_primdd(text, bigint, double precision, OUT seq bigint, OUT depth bigint, OUT start_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: plpgsql
Kind: function

pgr_primDD(Single Vertex)

Undirected graph
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- From root vertex identifier
- Distance
DocumentatiEdgeson:
- https://docs.pgrouting.org/latest/en/pgr_primDD.html

pgr_primdd(text, anyarray, numeric, OUT seq bigint, OUT depth bigint, OUT start_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: plpgsql
Kind: function

pgr_primDD(Multiple Vertices)

Undirected graph
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- From ARRAY[root vertices identifiers]
- Distance
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_primDD.html

pgr_primdd(text, anyarray, double precision, OUT seq bigint, OUT depth bigint, OUT start_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: plpgsql
Kind: function

pgr_primDD(Multiple Vertices)

Undirected graph
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- From ARRAY[root vertices identifiers]
- Distance
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_primDD.html

pgr_primdfs(text, bigint, max_depth bigint DEFAULT '9223372036854775807'::bigint, OUT seq bigint, OUT depth bigint, OUT start_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: plpgsql
Kind: function

pgr_primDFS(Single Vertex)

Undirected graph
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- From root vertex identifier
Optional parameters
- max_depth := 9223372036854775807
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_primDFS.html

pgr_primdfs(text, anyarray, max_depth bigint DEFAULT '9223372036854775807'::bigint, OUT seq bigint, OUT depth bigint, OUT start_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: plpgsql
Kind: function

pgr_primDFS(Multiple Vertices)

Undirected graph
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- From ARRAY[root vertices identifiers]
Optional parameters
- max_depth := 9223372036854775807
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_primDFS.html

pgr_pushrelabel(text, bigint, bigint, OUT seq integer, OUT edge bigint, OUT start_vid bigint, OUT end_vid bigint, OUT flow bigint, OUT residual_capacity bigint)

Returns: SETOF record
Language: sql
Kind: function

pgr_pushRelabel(One to One)

Directed graph
Parameters:
- Edges SQL with columns: id, source, target, capacity [,reverse_capacity]
- From vertex identifier
- To vertex identifier
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_pushRelabel.html

pgr_pushrelabel(text, bigint, anyarray, OUT seq integer, OUT edge bigint, OUT start_vid bigint, OUT end_vid bigint, OUT flow bigint, OUT residual_capacity bigint)

Returns: SETOF record
Language: sql
Kind: function

pgr_pushRelabel(One to Many)

Directed graph
Parameters:
- Edges SQL with columns: id, source, target, capacity [,reverse_capacity]
- From vertex identifie
- To ARRAY[vertices identifiers]
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_pushRelabel.html

pgr_pushrelabel(text, anyarray, bigint, OUT seq integer, OUT edge bigint, OUT start_vid bigint, OUT end_vid bigint, OUT flow bigint, OUT residual_capacity bigint)

Returns: SETOF record
Language: sql
Kind: function

pgr_pushRelabel(Many to One)

Directed graph
Parameters:
- Edges SQL with columns: id, source, target, capacity [,reverse_capacity]
- From ARRAY[vertices identifiers]
- To vertex identifie
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_pushRelabel.html

pgr_pushrelabel(text, anyarray, anyarray, OUT seq integer, OUT edge bigint, OUT start_vid bigint, OUT end_vid bigint, OUT flow bigint, OUT residual_capacity bigint)

Returns: SETOF record
Language: sql
Kind: function

pgr_pushRelabel(Many to Many)

Directed graph
Parameters:
- Edges SQL with columns: id, source, target, capacity [,reverse_capacity]
- From ARRAY[vertices identifiers]
- To ARRAY[vertices identifiers]
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_pushRelabel.html

pgr_pushrelabel(text, text, OUT seq integer, OUT edge bigint, OUT start_vid bigint, OUT end_vid bigint, OUT flow bigint, OUT residual_capacity bigint)

Returns: SETOF record
Language: sql
Kind: function

pgr_pushRelabel(Combinations)

Directed graph
Parameters:
- Edges SQL with columns: id, source, target, capacity [,reverse_capacity]
- Combinations SQL with columns: source, target
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_pushRelabel.html

pgr_sequentialvertexcoloring(text, OUT vertex_id bigint, OUT color_id bigint)

Returns: SETOF record
Language: plpgsql
Kind: function

pgr_sequentialVertexColoring

PROPOSED
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_sequentialVertexColoring.html

pgr_stoerwagner(text, OUT seq integer, OUT edge bigint, OUT cost double precision, OUT mincut double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_stoerWagner

EXPERIMENTAL
Undirected graph
Parameters:
- edges SQL with columns: id, source, target, cost [,reverse_cost]
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_stoerWagner.html

pgr_strongcomponents(text, OUT seq bigint, OUT component bigint, OUT node bigint)

Returns: SETOF record
Language: sql
Kind: function

pgr_strongComponents

Directed graph
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_strongComponents.html

pgr_topologicalsort(text, OUT seq integer, OUT sorted_v bigint)

Returns: SETOF record
Language: sql
Kind: function

pgr_topologicalSort

EXPERIMENTAL
Directed graph
Parameters:
- edges SQL with columns: id, source, target, cost [,reverse_cost]
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_topologicalSort.html

pgr_transitiveclosure(text, OUT seq integer, OUT vid bigint, OUT target_array bigint[])

Returns: SETOF record
Language: sql
Kind: function

pgr_transitiveClosure

EXPERIMENTAL
Directed graph
Parameters:
- edges SQL with columns: id, source, target, cost [,reverse_cost]
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_transitiveClosure.html

pgr_trsp(text, text, bigint, bigint, directed boolean DEFAULT true, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_trsp(one to one)

PROPOSED
Parameters
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- Restrictions SQL with columns: cost, path
- Departure vertex identifier
- Destination vertex identifier
Optional parameters
- directed
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_trsp.html

pgr_trsp(text, text, bigint, anyarray, directed boolean DEFAULT true, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_trsp(one to many)

PROPOSED
Parameters
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- Restrictions SQL with columns: cost, path
- Departure vertex identifier
- Destinations ARRAY[vertices identifier]
Optional parameters
- directed := true
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_trsp.html

pgr_trsp(text, text, anyarray, bigint, directed boolean DEFAULT true, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_trsp(many to one)

PROPOSED
Parameters
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- Restrictions SQL with columns: cost, path
- Departures ARRAY[vertices identifier]
- Destination vertex identifier
Optional parameters
- directed := true
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_trsp.html

pgr_trsp(text, text, anyarray, anyarray, directed boolean DEFAULT true, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_trsp(many to many)

PROPOSED
Parameters
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- Restrictions SQL with columns: cost, path
- Departures ARRAY[vertices identifier]
- Destinations ARRAY[vertices identifier]
Optional parameters
- directed := true
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_trsp.html

pgr_trsp(text, text, text, directed boolean DEFAULT true, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_trsp(combinations)

PROPOSED
Parameters
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- Restrictions SQL with columns: cost, path
- Combinations SQL with columns: source, target
Optional parameters
- directed := true
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_trsp.html

pgr_trsp(text, integer, integer, boolean, boolean, restrictions_sql text DEFAULT NULL::text, OUT seq integer, OUT id1 integer, OUT id2 integer, OUT cost double precision)

Returns: SETOF record
Language: plpgsql
Kind: function

pgr_trsp

DEPRECATED signature on v3.4.0
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_trsp.html

pgr_trsp(text, integer, double precision, integer, double precision, boolean, boolean, turn_restrict_sql text DEFAULT NULL::text, OUT seq integer, OUT id1 integer, OUT id2 integer, OUT cost double precision)

Returns: SETOF record
Language: plpgsql
Kind: function

pgr_trsp

DEPRECATED signature on v3.4.0
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_trsp_withPoints.html

pgr_trsp_withpoints(text, text, text, bigint, bigint, directed boolean DEFAULT true, driving_side character DEFAULT 'r'::bpchar, details boolean DEFAULT false, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_trsp_withPoints (One to One)

PROPOSED
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- Restrictions SQL with columns: id, cost, path
- Points SQL with columns: [pid], edge_id, fraction [,side]
- Departure vertex/point identifier
- Destination vertex/point identifier
Optional Parameters:
- directed := 'true'
- driving_side := 'r'
- details := 'false'
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_trsp_withPoints.html

pgr_trsp_withpoints(text, text, text, bigint, anyarray, directed boolean DEFAULT true, driving_side character DEFAULT 'r'::bpchar, details boolean DEFAULT false, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_trsp_withPoints(One to Many)

PROPOSED
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- Restrictions SQL with columns: id, cost, path
- Points SQL with columns: [pid], edge_id, fraction [,side]
- Departure vertex/point identifier
- Destinations ARRAY[vertices/Points identifier]
Optional Parameters:
- directed := 'true'
- driving_side := 'r'
- details := 'false'
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_trsp_withPoints.html

pgr_trsp_withpoints(text, text, text, anyarray, bigint, directed boolean DEFAULT true, driving_side character DEFAULT 'r'::bpchar, details boolean DEFAULT false, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_trsp_withPoints(Many to One)

PROPOSED
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- Restrictions SQL with columns: id, cost, path
- Points SQL with columns: [pid], edge_id, fraction [,side]
- Departures ARRAY[vertices/Points identifier]
- Destination vertex/point identifier
Optional Parameters:
- directed := 'true'
- driving_side := 'r'
- details := 'false'
Documentation:
https://docs.pgrouting.org/latest/en/pgr_trsp_withPoints.html

pgr_trsp_withpoints(text, text, text, anyarray, anyarray, directed boolean DEFAULT true, driving_side character DEFAULT 'r'::bpchar, details boolean DEFAULT false, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_trsp_withPoints(Many to Many)

PROPOSED
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- Restrictions SQL with columns: id, cost, path
- Points SQL with columns: [pid], edge_id, fraction [,side]
- Departures ARRAY[vertices/Points identifier]
- Destinations ARRAY[vertices/Points identifier]
Optional Parameters:
- directed := 'true'
- driving_side := 'r'
- details := 'false'
Documentation:
https://docs.pgrouting.org/latest/en/pgr_trsp_withPoints.html

pgr_trsp_withpoints(text, text, text, text, directed boolean DEFAULT true, driving_side character DEFAULT 'r'::bpchar, details boolean DEFAULT false, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_trsp_withPoints(Combinations)

Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- Restrictions SQL with columns: id, path, cost
- Points SQL with columns: [pid], edge_id, fraction [,side]
- Combinations SQL with columns: source, target
Optional Parameters:
- directed := 'true'
- driving_side := 'r'
- details := 'false'
Documentation:
https://docs.pgrouting.org/latest/en/pgr_trsp_withPoints.html

pgr_trspvia(text, text, anyarray, directed boolean DEFAULT true, strict boolean DEFAULT false, u_turn_on_edge boolean DEFAULT true, OUT seq integer, OUT path_id integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision, OUT route_agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_trspVia

PROPOSED
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- Restrictions SQL with columns: cost, path
- ARRAY[via vertices identifiers]
Optional Parameters
- directed := true
- strict := false
- U_turn_on_edge := true
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_trspVia.html

pgr_trspvia_withpoints(text, text, text, anyarray, directed boolean DEFAULT true, strict boolean DEFAULT false, u_turn_on_edge boolean DEFAULT true, driving_side character DEFAULT 'r'::bpchar, details boolean DEFAULT false, OUT seq integer, OUT path_id integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision, OUT route_agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_trspVia_withPoints

PROPOSED
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- Restrictions SQL with columns: cost, path
- Points SQL with columns: [pid], edge_id, fraction [,side]
- ARRAY[via vertices identifiers]
Optional Parameters
- directed := true
- strict := false
- U_turn_on_edge := true
- driving_side := 'r'
- details := 'false'
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_trspVia_withPoints.html

pgr_trspviaedges(text, integer[], double precision[], boolean, boolean, turn_restrict_sql text DEFAULT NULL::text, OUT seq integer, OUT id1 integer, OUT id2 integer, OUT id3 integer, OUT cost double precision)

Returns: SETOF record
Language: plpgsql
Kind: function

pgr_trspViaEdges

DEPRECATED function on v3.4.0
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_trspVia_withPoints.html

pgr_trspviavertices(text, anyarray, boolean, boolean, restrictions_sql text DEFAULT NULL::text, OUT seq integer, OUT id1 integer, OUT id2 integer, OUT id3 integer, OUT cost double precision)

Returns: SETOF record
Language: plpgsql
Kind: function

pgr_trspViaVertices

DEPRECATED function on v3.4.0
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_trspVia.html

pgr_tsp(text, start_id bigint DEFAULT 0, end_id bigint DEFAULT 0, max_processing_time double precision DEFAULT 'Infinity'::double precision, tries_per_temperature integer DEFAULT 500, max_changes_per_temperature integer DEFAULT 60, max_consecutive_non_changes integer DEFAULT 100, initial_temperature double precision DEFAULT 100, final_temperature double precision DEFAULT 0.1, cooling_factor double precision DEFAULT 0.9, randomize boolean DEFAULT true, OUT seq integer, OUT node bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_TSP

Parameters
- matrix SQL with columns: start_vid, end_vid, agg_cost
Optional parameters
- start_id := 0
- end_id := 0
- max_processing_time := '+infinity'::FLOAT
- tries_per_temperature := 500
- max_changes_per_temperature := 60
- max_consecutive_non_changes := 100
- initial_temperature FLOAT := 100
- final_temperature := 0.1
- cooling_factor := 0.9
- randomize := true
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_TSP.html

pgr_tspeuclidean(text, start_id bigint DEFAULT 0, end_id bigint DEFAULT 0, max_processing_time double precision DEFAULT 'Infinity'::double precision, tries_per_temperature integer DEFAULT 500, max_changes_per_temperature integer DEFAULT 60, max_consecutive_non_changes integer DEFAULT 100, initial_temperature double precision DEFAULT 100, final_temperature double precision DEFAULT 0.1, cooling_factor double precision DEFAULT 0.9, randomize boolean DEFAULT true, OUT seq integer, OUT node bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_TSPeuclidean

Parameters
- coordinates SQL with columns: id, x, y
Optional parameters
- start_id := 0
- end_id := 0
- max_processing_time := '+infinity'::FLOAT
- tries_per_temperature := 500
- max_changes_per_temperature := 60
- max_consecutive_non_changes := 100
- initial_temperature FLOAT := 100
- final_temperature := 0.1
- cooling_factor := 0.9
- randomize := true
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_TSPeuclidean.html

pgr_turnrestrictedpath(text, text, bigint, bigint, integer, directed boolean DEFAULT true, heap_paths boolean DEFAULT false, stop_on_first boolean DEFAULT true, strict boolean DEFAULT false, OUT seq integer, OUT path_id integer, OUT path_seq integer, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_turnRestrictedPath

EXPERIMENTAL
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- Restrictions SQL with columns: id, cost, path
- From vertex identifier
- To vertex identifier
- K
Optional Parameters
- directed := true
- heap paths := false
- stop on first := true
- strict := false
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_turnRestrictedPath.html

pgr_version()

Returns: text
Language: sql
Kind: function

pgr_version

Documentation
- https://docs.pgrouting.org/latest/en/pgr_version.html

pgr_vrponedepot(text, text, text, integer, OUT oid integer, OUT opos integer, OUT vid integer, OUT tarrival integer, OUT tdepart integer)

Returns: SETOF record
Language: sql
Kind: function

pgr_vrpOneDepot

EXPERIMENTAL
Parameters
- orders SQL with columns: id, x, y, order_unit, open_time, close_time, service_time
- vehicle SQL with columns: vehicle_id, capacity, case_no
- cost SQL with columns: src_id, dest_id, cost, distance, traveltime
- depot id
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_vrpOneDepot.html

pgr_withpoints(text, text, bigint, bigint, directed boolean DEFAULT true, driving_side character DEFAULT 'b'::bpchar, details boolean DEFAULT false, OUT seq integer, OUT path_seq integer, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_withPoints (One to One)

PROPOSED
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- Points SQL with columns: [pid], edge_id, fraction[,side]
- From vertex identifier/point identifier
- To vertex identifier/point identifier
Optional Parameters
- directed := 'true'
- driving_side := 'b'
- details := 'false'
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_withPoints.html

pgr_withpoints(text, text, bigint, anyarray, directed boolean DEFAULT true, driving_side character DEFAULT 'b'::bpchar, details boolean DEFAULT false, OUT seq integer, OUT path_seq integer, OUT end_pid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_withPoints (One to Many)

PROPOSED
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- Points SQL with columns: [pid], edge_id, fraction[,side]
- From vertex identifier/point identifier
- To ARRAY[vertices/points identifier]
Optional Parameters
- directed := 'true'
- driving_side := 'b'
- details := 'false'
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_withPoints.html

pgr_withpoints(text, text, anyarray, bigint, directed boolean DEFAULT true, driving_side character DEFAULT 'b'::bpchar, details boolean DEFAULT false, OUT seq integer, OUT path_seq integer, OUT start_pid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_withPoints (Many to One)

PROPOSED
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- Points SQL with columns: [pid], edge_id, fraction[,side]
- From ARRAY[vertices/points identifiers]
- To vertex identifier/point identifier
Optional Parameters
- directed := 'true'
- driving_side := 'b'
- details := 'false'
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_withPoints.html

pgr_withpoints(text, text, anyarray, anyarray, directed boolean DEFAULT true, driving_side character DEFAULT 'b'::bpchar, details boolean DEFAULT false, OUT seq integer, OUT path_seq integer, OUT start_pid bigint, OUT end_pid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_withPoints (Many to Many)

PROPOSED
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- Points SQL with columns: [pid], edge_id, fraction[,side]
- From ARRAY[vertices/points identifiers]
- To ARRAY[vertices/points identifiers]
Optional Parameters
- directed := 'true'
- driving_side := 'b'
- details := 'false'
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_withPoints.html

pgr_withpoints(text, text, text, directed boolean DEFAULT true, driving_side character DEFAULT 'b'::bpchar, details boolean DEFAULT false, OUT seq integer, OUT path_seq integer, OUT start_pid bigint, OUT end_pid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_withPoints(Combinations)

Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- Points SQL with columns: [pid], edge_id, fraction [,side]
- Combinations SQL with columns: source, target
Optional Parameters
- directed := 'true'
- driving_side := 'b'
- details := 'false'
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_withPoints.html

pgr_withpointscost(text, text, bigint, bigint, directed boolean DEFAULT true, driving_side character DEFAULT 'b'::bpchar, OUT start_pid bigint, OUT end_pid bigint, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_withPointsCost (One to One)

PROPOSED
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- Points SQL with columns: [pid], edge_id, fraction[,side]
- From vertex/point identifier
- To vertex/point identifier
Optional Parameters
- directed := 'true'
- driving_side := 'b'
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_withPointsCost.html

pgr_withpointscost(text, text, bigint, anyarray, directed boolean DEFAULT true, driving_side character DEFAULT 'b'::bpchar, OUT start_pid bigint, OUT end_pid bigint, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_withPointsCost (One to Many)

PROPOSED
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- Points SQL with columns: [pid], edge_id, fraction[,side]
- From vertex/point identifier
- To ARRAY[vertices/points identifiers]
Optional Parameters
- directed := 'true'
- driving_side := 'b'
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_withPointsCost.html

pgr_withpointscost(text, text, anyarray, bigint, directed boolean DEFAULT true, driving_side character DEFAULT 'b'::bpchar, OUT start_pid bigint, OUT end_pid bigint, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_withPointsCost (Many to One)

PROPOSED
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- Points SQL with columns: [pid], edge_id, fraction[,side]
- From ARRAY[vertices/points identifiers]
- To vertex/point identifier
Optional Parameters
- directed := 'true'
- driving_side := 'b'
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_withPointsCost.html

pgr_withpointscost(text, text, anyarray, anyarray, directed boolean DEFAULT true, driving_side character DEFAULT 'b'::bpchar, OUT start_pid bigint, OUT end_pid bigint, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_withPointsCost (Many to Many)

Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- Points SQL with columns: [pid], edge_id, fraction[,side]
- From ARRAY[vertices/points identifiers]
- To ARRAY[vertices/points identifiers]
Optional Parameters
- directed := 'true'
- driving_side := 'b'
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_withPointsCost.html

pgr_withpointscost(text, text, text, directed boolean DEFAULT true, driving_side character DEFAULT 'b'::bpchar, OUT start_pid bigint, OUT end_pid bigint, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_withPointsCost(Combinations)

Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- Points SQL with columns: [pid], edge_id, fraction [,side]
- Combinations SQL with columns: source, target
Optional Parameters
- directed := 'true'
- driving_side := 'b'
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_withPointsCost.html

pgr_withpointscostmatrix(text, text, anyarray, directed boolean DEFAULT true, driving_side character DEFAULT 'b'::bpchar, OUT start_vid bigint, OUT end_vid bigint, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_withPointsCostMatrix

PROPOSED
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- Points SQL with columns: [pid], edge_id, fraction[,side]
- ARRAY [points identifiers],
Optional Parameters
- directed := true
- driving_side := 'b'
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_withPointsCostMatrix.html

pgr_withpointsdd(text, text, bigint, double precision, directed boolean DEFAULT true, driving_side character DEFAULT 'b'::bpchar, details boolean DEFAULT false, OUT seq integer, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_withPointsDD(Single Vertex)

PROPOSED
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- Points SQL with columns: [pid], edge_id, fraction[,side]
- From vertex identifier
- Distance
Optional Parameters
- directed := true
- driving_side := b
- details := false
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_withPointsDD.html

pgr_withpointsdd(text, text, anyarray, double precision, directed boolean DEFAULT true, driving_side character DEFAULT 'b'::bpchar, details boolean DEFAULT false, equicost boolean DEFAULT false, OUT seq integer, OUT start_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_withPointsDD(Multiple Vertices)

PROPOSED
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- Points SQL with columns: [pid], edge_id, fraction[,side]
- From ARRAY[vertices identifiers]
- Distance
Optional Parameters
- directed := true
- driving_side := b
- details := false
- equicost := false
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_withPointsDD.html

pgr_withpointsksp(text, text, bigint, bigint, integer, directed boolean DEFAULT true, heap_paths boolean DEFAULT false, driving_side character DEFAULT 'b'::bpchar, details boolean DEFAULT false, OUT seq integer, OUT path_id integer, OUT path_seq integer, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_withPointsKSP

PROPOSED
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- Points SQL with columns: [pid], edge_id, fraction[,side]
- From vertex identifier
- To vertex identifier
- K
Optional Parameters
- directed := true
- heap paths := false
- driving side := b
- details := false
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_withPointsKSP.html

pgr_withpointsvia(text, text, anyarray, directed boolean DEFAULT true, strict boolean DEFAULT false, u_turn_on_edge boolean DEFAULT true, driving_side character DEFAULT 'b'::bpchar, details boolean DEFAULT false, OUT seq integer, OUT path_id integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision, OUT route_agg_cost double precision)

Returns: SETOF record
Language: sql
Kind: function

pgr_withPointsVia

PROPOSED
Parameters:
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
- Points SQL with columns: [pid], edge_id, fraction [,side]
- ARRAY[via vertices identifiers]
Optional Parameters
- directed := true
- strict := false
- U_turn_on_edge := true
- driving_side := 'b'
- details := 'false'
Documentation:
- https://docs.pgrouting.org/latest/en/pgr_withPointsVia.html

remove_account_member(account_id uuid, user_id uuid)

Returns: void
Language: plpgsql
Kind: function

service_role_upsert_customer_subscription(account_id uuid, customer jsonb DEFAULT NULL::jsonb, subscription jsonb DEFAULT NULL::jsonb)

Returns: void
Language: plpgsql
Kind: function

set_parent_account(child_account_id uuid, parent_account_id uuid, relation_type account_relation_type DEFAULT 'owner-of'::account_relation_type)

Returns: void
Language: plpgsql
Kind: function

update_account(account_id uuid, slug text DEFAULT NULL::text, name text DEFAULT NULL::text, public_metadata jsonb DEFAULT NULL::jsonb, replace_metadata boolean DEFAULT false)

Returns: json
Language: plpgsql
Kind: function

update_account_user_role(account_id uuid, user_id uuid, new_account_role basejump.account_role, make_primary_owner boolean DEFAULT false)

Returns: void
Language: plpgsql
Kind: function
SECURITY DEFINER

Tables (24)
Views (8)
Functions (358)

Tables (24)​

account_account​

account_category​

account_category_user​

accounting_category​

activity​

category​

category_submission​

country​

currency_rate​

destination​

emission​

emission_factor​

error_code​

imported_addresses_list​

imported_addresses_missing_letters​

imported_list​

imported_routes_list​

imported_sources​

nace_category​

order​

report​

report_status​

route_data​

settings​

Views (8)​

view_accounting_categories​

view_activities_with_emissions​

view_categories_overview​

view_category_submissions​

view_emission_factors​

view_imported_list_errors​

view_imported_list_status​

view_suppliers​

Functions (358)​

_pgr_alphashape(text, alpha double precision DEFAULT 0, OUT seq1 bigint, OUT textgeom text)​

_pgr_array_reverse(anyarray)​

_pgr_articulationpoints(edges_sql text, OUT seq integer, OUT node bigint)​

_pgr_bddijkstra(text, anyarray, anyarray, directed boolean, only_cost boolean DEFAULT false, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)​

_pgr_bddijkstra(text, text, directed boolean, only_cost boolean DEFAULT false, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)​

_pgr_bellmanford(edges_sql text, from_vids anyarray, to_vids anyarray, directed boolean, only_cost boolean, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)​

_pgr_bellmanford(edges_sql text, combinations_sql text, directed boolean, only_cost boolean, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)​

_pgr_biconnectedcomponents(edges_sql text, OUT seq bigint, OUT component bigint, OUT edge bigint)​

_pgr_binarybreadthfirstsearch(edges_sql text, from_vids anyarray, to_vids anyarray, directed boolean DEFAULT true, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)​

_pgr_binarybreadthfirstsearch(edges_sql text, combinations_sql text, directed boolean DEFAULT true, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)​

_pgr_bipartite(edges_sql text, OUT node bigint, OUT color bigint)​

_pgr_boost_version()​

_pgr_breadthfirstsearch(edges_sql text, from_vids anyarray, max_depth bigint, directed boolean, OUT seq bigint, OUT depth bigint, OUT start_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)​

_pgr_bridges(edges_sql text, OUT seq integer, OUT edge bigint)​

_pgr_build_type()​

_pgr_checkcolumn(text, text, text, is_optional boolean DEFAULT false, dryrun boolean DEFAULT false)​

_pgr_checkquery(text)​

_pgr_checkverttab(vertname text, columnsarr text[], reporterrs integer DEFAULT 1, fnname text DEFAULT '_pgr_checkVertTab'::text, OUT sname text, OUT vname text)​

_pgr_chinesepostman(edges_sql text, only_cost boolean, OUT seq integer, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)​

_pgr_compilation_date()​

_pgr_compiler_version()​

_pgr_connectedcomponents(edges_sql text, OUT seq bigint, OUT component bigint, OUT node bigint)​

_pgr_createindex(sname text, tname text, colname text, indext text, reporterrs integer DEFAULT 1, fnname text DEFAULT '_pgr_createIndex'::text)​

_pgr_createindex(tabname text, colname text, indext text, reporterrs integer DEFAULT 1, fnname text DEFAULT '_pgr_createIndex'::text)​

_pgr_cuthillmckeeordering(text, OUT seq bigint, OUT node bigint)​

_pgr_dagshortestpath(text, anyarray, anyarray, directed boolean DEFAULT true, only_cost boolean DEFAULT false, OUT seq integer, OUT path_seq integer, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)​

_pgr_dagshortestpath(text, text, directed boolean DEFAULT true, only_cost boolean DEFAULT false, OUT seq integer, OUT path_seq integer, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)​

_pgr_depthfirstsearch(edges_sql text, root_vids anyarray, directed boolean, max_depth bigint, OUT seq bigint, OUT depth bigint, OUT start_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)​

_pgr_dijkstra(edges_sql text, combinations_sql text, directed boolean, only_cost boolean, n_goals bigint, global boolean, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)​

_pgr_dijkstranear(text, bigint, anyarray, bigint, directed boolean DEFAULT true, OUT seq integer, OUT path_seq integer, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)​

_pgr_dijkstranear(text, anyarray, bigint, bigint, directed boolean DEFAULT true, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)​

_pgr_dijkstranear(text, anyarray, anyarray, bigint, directed boolean DEFAULT true, OUT seq integer, OUT path_seq integer, OUT end_vid bigint, OUT start_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)​

_pgr_drivingdistance(edges_sql text, start_vids anyarray, distance double precision, directed boolean DEFAULT true, equicost boolean DEFAULT false, OUT seq integer, OUT from_v bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)​

_pgr_edgecoloring(edges_sql text, OUT edge_id bigint, OUT color_id bigint)​

_pgr_edgedisjointpaths(text, anyarray, anyarray, directed boolean, OUT seq integer, OUT path_id integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)​

_pgr_edgedisjointpaths(text, text, directed boolean, OUT seq integer, OUT path_id integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)​

_pgr_edwardmoore(edges_sql text, from_vids anyarray, to_vids anyarray, directed boolean DEFAULT true, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)​

_pgr_edwardmoore(edges_sql text, combinations_sql text, directed boolean DEFAULT true, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)​

_pgr_endpoint(g gis.geometry)​

_pgr_floydwarshall(edges_sql text, directed boolean, OUT start_vid bigint, OUT end_vid bigint, OUT agg_cost double precision)​

_pgr_get_statement(o_sql text)​

_pgr_getcolumnname(sname text, tname text, col text, reporterrs integer DEFAULT 1, fnname text DEFAULT '_pgr_getColumnName'::text)​

_pgr_getcolumnname(tab text, col text, reporterrs integer DEFAULT 1, fnname text DEFAULT '_pgr_getColumnName'::text)​

_pgr_getcolumntype(sname text, tname text, cname text, reporterrs integer DEFAULT 0, fnname text DEFAULT '_pgr_getColumnType'::text)​

_pgr_getcolumntype(tab text, col text, reporterrs integer DEFAULT 0, fnname text DEFAULT '_pgr_getColumnType'::text)​

Tables (24)

account_account

account_category

account_category_user

accounting_category

activity

category

category_submission

country

currency_rate

destination

emission

emission_factor

error_code

imported_addresses_list

imported_addresses_missing_letters

imported_list

imported_routes_list

imported_sources

nace_category

order

report

report_status

route_data

settings

Views (8)

view_accounting_categories

view_activities_with_emissions

view_categories_overview

view_category_submissions

view_emission_factors

view_imported_list_errors

view_imported_list_status

view_suppliers

Functions (358)

_pgr_alphashape(text, alpha double precision DEFAULT 0, OUT seq1 bigint, OUT textgeom text)

_pgr_array_reverse(anyarray)

_pgr_articulationpoints(edges_sql text, OUT seq integer, OUT node bigint)

_pgr_bddijkstra(text, anyarray, anyarray, directed boolean, only_cost boolean DEFAULT false, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

_pgr_bddijkstra(text, text, directed boolean, only_cost boolean DEFAULT false, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

_pgr_bellmanford(edges_sql text, from_vids anyarray, to_vids anyarray, directed boolean, only_cost boolean, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

_pgr_bellmanford(edges_sql text, combinations_sql text, directed boolean, only_cost boolean, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

_pgr_biconnectedcomponents(edges_sql text, OUT seq bigint, OUT component bigint, OUT edge bigint)

_pgr_binarybreadthfirstsearch(edges_sql text, from_vids anyarray, to_vids anyarray, directed boolean DEFAULT true, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

_pgr_binarybreadthfirstsearch(edges_sql text, combinations_sql text, directed boolean DEFAULT true, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

_pgr_bipartite(edges_sql text, OUT node bigint, OUT color bigint)

_pgr_boost_version()

_pgr_breadthfirstsearch(edges_sql text, from_vids anyarray, max_depth bigint, directed boolean, OUT seq bigint, OUT depth bigint, OUT start_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

_pgr_bridges(edges_sql text, OUT seq integer, OUT edge bigint)

_pgr_build_type()

_pgr_checkcolumn(text, text, text, is_optional boolean DEFAULT false, dryrun boolean DEFAULT false)

_pgr_checkquery(text)

_pgr_checkverttab(vertname text, columnsarr text[], reporterrs integer DEFAULT 1, fnname text DEFAULT '_pgr_checkVertTab'::text, OUT sname text, OUT vname text)

_pgr_chinesepostman(edges_sql text, only_cost boolean, OUT seq integer, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

_pgr_compilation_date()

_pgr_compiler_version()

_pgr_connectedcomponents(edges_sql text, OUT seq bigint, OUT component bigint, OUT node bigint)

_pgr_createindex(sname text, tname text, colname text, indext text, reporterrs integer DEFAULT 1, fnname text DEFAULT '_pgr_createIndex'::text)

_pgr_createindex(tabname text, colname text, indext text, reporterrs integer DEFAULT 1, fnname text DEFAULT '_pgr_createIndex'::text)

_pgr_cuthillmckeeordering(text, OUT seq bigint, OUT node bigint)

_pgr_dagshortestpath(text, anyarray, anyarray, directed boolean DEFAULT true, only_cost boolean DEFAULT false, OUT seq integer, OUT path_seq integer, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

_pgr_dagshortestpath(text, text, directed boolean DEFAULT true, only_cost boolean DEFAULT false, OUT seq integer, OUT path_seq integer, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

_pgr_depthfirstsearch(edges_sql text, root_vids anyarray, directed boolean, max_depth bigint, OUT seq bigint, OUT depth bigint, OUT start_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

_pgr_dijkstra(edges_sql text, combinations_sql text, directed boolean, only_cost boolean, n_goals bigint, global boolean, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

_pgr_dijkstranear(text, bigint, anyarray, bigint, directed boolean DEFAULT true, OUT seq integer, OUT path_seq integer, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

_pgr_dijkstranear(text, anyarray, bigint, bigint, directed boolean DEFAULT true, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

_pgr_dijkstranear(text, anyarray, anyarray, bigint, directed boolean DEFAULT true, OUT seq integer, OUT path_seq integer, OUT end_vid bigint, OUT start_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

_pgr_drivingdistance(edges_sql text, start_vids anyarray, distance double precision, directed boolean DEFAULT true, equicost boolean DEFAULT false, OUT seq integer, OUT from_v bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

_pgr_edgecoloring(edges_sql text, OUT edge_id bigint, OUT color_id bigint)

_pgr_edgedisjointpaths(text, anyarray, anyarray, directed boolean, OUT seq integer, OUT path_id integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

_pgr_edgedisjointpaths(text, text, directed boolean, OUT seq integer, OUT path_id integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

_pgr_edwardmoore(edges_sql text, from_vids anyarray, to_vids anyarray, directed boolean DEFAULT true, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

_pgr_edwardmoore(edges_sql text, combinations_sql text, directed boolean DEFAULT true, OUT seq integer, OUT path_seq integer, OUT start_vid bigint, OUT end_vid bigint, OUT node bigint, OUT edge bigint, OUT cost double precision, OUT agg_cost double precision)

_pgr_endpoint(g gis.geometry)

_pgr_floydwarshall(edges_sql text, directed boolean, OUT start_vid bigint, OUT end_vid bigint, OUT agg_cost double precision)

_pgr_get_statement(o_sql text)

_pgr_getcolumnname(sname text, tname text, col text, reporterrs integer DEFAULT 1, fnname text DEFAULT '_pgr_getColumnName'::text)

_pgr_getcolumnname(tab text, col text, reporterrs integer DEFAULT 1, fnname text DEFAULT '_pgr_getColumnName'::text)

_pgr_getcolumntype(sname text, tname text, cname text, reporterrs integer DEFAULT 0, fnname text DEFAULT '_pgr_getColumnType'::text)

_pgr_getcolumntype(tab text, col text, reporterrs integer DEFAULT 0, fnname text DEFAULT '_pgr_getColumnType'::text)