pgRouting Manual (2.0.0)

pgr_isColumnInTable

«  pgr_isColumnIndexed   ::   Contents   ::   pgr_pointToId  »

pgr_isColumnInTable

Name

pgr_isColumnInTable — Check if a column is in the table.

Note

This function is intended for the developer’s aid.

Synopsis

Returns true when the column “col” is in table “tab”.

boolean pgr_isColumnInTable(text tab, text col);

Description

tab:text Table name with or without schema component.
col:text Column name to be checked for.

Returns:

  • true when the column “col” is in table “tab”.
  • false when:
  • The table “tab” is not found or
  • Column “col” is not found in table “tab”

History

  • New in version 2.0.0

Examples

SELECT pgr_isColumnInTable('edge_table','x1');

 pgr_iscolumnintable
---------------------
 t
(1 row)

SELECT pgr_isColumnInTable('public.edge_table','foo');

 pgr_iscolumnintable
---------------------
 f
(1 row)

The example use the Sample Data network.

See Also

«  pgr_isColumnIndexed   ::   Contents   ::   pgr_pointToId  »