Skip to content

Instantly share code, notes, and snippets.

@PMeinshausen

PMeinshausen/Path_Start.sql

Created September 18, 2014 11:13
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save PMeinshausen/697ef4725b9a6ef682fc to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save PMeinshausen/697ef4725b9a6ef682fc to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Path_Start.sql
--Syntax (version 1.1)
SELECT * FROM Path_Start(
ON table_name
PARTITION BY expression [, ...]
CNT('count-column')
[DELIMITER(',')]
PARENT('parent-column')
PARTITIONNAMES('partitionby-col-name' [, ...])
NODE('node-column')
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment