Skip to content

Instantly share code, notes, and snippets.

@iakio
Created October 30, 2013 11:26
Show Gist options
  • Save iakio/7231100 to your computer and use it in GitHub Desktop.
Save iakio/7231100 to your computer and use it in GitHub Desktop.
set return functionの引数が他のテーブルを参照していたらどうなるのか
ishida=# select * from generate_series(1, 3) as i, generate_series(1, i) as j;
i | j
---+---
1 | 1
2 | 1
2 | 2
3 | 1
3 | 2
3 | 3
(6 行)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment