{"Entry":{"collection":"func","key":"generate-series","name":"generate_series","aliases":[],"metadata":{"changed_in":["8.4","9.5","16"],"changes":[{"descriptions_changed":false,"doc_overhaul":false,"from":"7.4","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"added","to":"8.0"},{"descriptions_changed":false,"doc_overhaul":false,"from":"8.3","group_changed":null,"signatures":{"added":["generate_series ( start, stop, step interval ) → setof timestamp or setof timestamp with time zone (same as argument type)"],"removed":[]},"status":"changed","to":"8.4"},{"descriptions_changed":false,"doc_overhaul":false,"from":"9.4","group_changed":null,"signatures":{"added":["generate_series ( start, stop ) → setof int, setof bigint, or setof numeric (same as argument type)","generate_series ( start, stop, step ) → setof int, setof bigint or setof numeric (same as argument type)"],"removed":["generate_series ( start, stop ) → setof int or setof bigint (same as argument type)","generate_series ( start, stop, step ) → setof int or setof bigint (same as argument type)"]},"status":"changed","to":"9.5"},{"descriptions_changed":false,"doc_overhaul":true,"from":"12","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"changed","to":"13"},{"descriptions_changed":false,"doc_overhaul":false,"from":"15","group_changed":null,"signatures":{"added":["generate_series ( start timestamp with time zone, stop timestamp with time zone, step interval [, timezone text ] ) → setof timestamp with time zone"],"removed":["generate_series ( start timestamp with time zone, stop timestamp with time zone, step interval ) → setof timestamp with time zone"]},"status":"changed","to":"16"}],"content_hash":"d1f95cb08e911950ff08c2fd86ec817e4bc44a41005e9ec838f64fe9ede50994","derived_content_hash":"70862088983fd23f499bf7d964e6218d0e5ef8f0d90e39e56e8fbd76b4362e71","first_version":"8.0","group":"srf","group_label":"Set Returning Functions","groups":["srf"],"imported_at":"2026-09-27T17:57:29.016849+08:00","last_version":"20","name":"generate_series","name_key":"generate_series","position":26000,"present_in":["8.0","8.1","8.2","8.3","8.4","9.0","9.1","9.2","9.3","9.4","9.5","9.6","10","11","12","13","14","15","16","17","18","19","20"],"repair_provenance":{"original_source_revision":"b7bd9cda","receipt_sha256":"aa2ac8381ed9ed431de64008802c3529e1c3c48249b459d6d4112394aa4f3509","repair":"wiki-repair-20261023"},"signature":"generate_series ( start integer, stop integer [, step integer ] ) → setof integer","signature_count":5,"slug":"generate-series","source_rev":"wiki-repair-20261023:1c2304e30569a0aebdaeba0dd4c7971094d93c08102f5e19dbbab56207d69e79","summary":"Generates a series of values from start to stop, with a step size of step.","summary_zh":""}},"Definition":{"Collection":"func","Key":"generate-series","SourceDatabase":"center","Version":"18","SourceTable":"func","SourceKey":"generate-series","SourceRevision":"wiki-repair-20261023:1c2304e30569a0aebdaeba0dd4c7971094d93c08102f5e19dbbab56207d69e79","Facts":{"description":"Generates a series of values from start to stop, with a step size of step. step defaults to 1.","description_html":"Generates a series of values from \u003cem class=\"parameter\"\u003e\u003ccode\u003estart\u003c/code\u003e\u003c/em\u003e to \u003cem class=\"parameter\"\u003e\u003ccode\u003estop\u003c/code\u003e\u003c/em\u003e, with a step size of \u003cem class=\"parameter\"\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e. \u003cem class=\"parameter\"\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e defaults to 1.","description_zh":"从 start 到 stop 生成一系列的值，步长为 step。step 默认为 1。","description_zh_html":"从 \u003cem class=\"parameter\"\u003e\u003ccode\u003estart\u003c/code\u003e\u003c/em\u003e 到 \u003cem class=\"parameter\"\u003e\u003ccode\u003estop\u003c/code\u003e\u003c/em\u003e 生成一系列的值，步长为 \u003cem class=\"parameter\"\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e。\u003cem class=\"parameter\"\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e 默认为 1。","doc":{"anchor":"FUNCTIONS-SRF-SERIES","file":"functions-srf.html","slug":"18"},"group":"srf","group_label":"Set Returning Functions","lang":"en","layout":"table-new","pages":["functions-srf.html"],"prose_only":false,"signatures":[{"description":"Generates a series of values from start to stop, with a step size of step. step defaults to 1.","description_html":"Generates a series of values from \u003cem class=\"parameter\"\u003e\u003ccode\u003estart\u003c/code\u003e\u003c/em\u003e to \u003cem class=\"parameter\"\u003e\u003ccode\u003estop\u003c/code\u003e\u003c/em\u003e, with a step size of \u003cem class=\"parameter\"\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e. \u003cem class=\"parameter\"\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e defaults to 1.","description_zh":"从 start 到 stop 生成一系列的值，步长为 step。step 默认为 1。","description_zh_html":"从 \u003cem class=\"parameter\"\u003e\u003ccode\u003estart\u003c/code\u003e\u003c/em\u003e 到 \u003cem class=\"parameter\"\u003e\u003ccode\u003estop\u003c/code\u003e\u003c/em\u003e 生成一系列的值，步长为 \u003cem class=\"parameter\"\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e。\u003cem class=\"parameter\"\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e 默认为 1。","examples":[],"html":"\u003ccode class=\"function\"\u003egenerate_series\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003estart\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003einteger\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003estop\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003einteger\u003c/code\u003e [\u003cspan class=\"optional\"\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003einteger\u003c/code\u003e\u003c/span\u003e ] ) → \u003ccode class=\"returnvalue\"\u003esetof integer\u003c/code\u003e","returns":"setof integer","text":"generate_series ( start integer, stop integer [, step integer ] ) → setof integer","zh_from":"same-version-pgdoc"},{"description":"Generates a series of values from start to stop, with a step size of step. step defaults to 1.","description_html":"Generates a series of values from \u003cem class=\"parameter\"\u003e\u003ccode\u003estart\u003c/code\u003e\u003c/em\u003e to \u003cem class=\"parameter\"\u003e\u003ccode\u003estop\u003c/code\u003e\u003c/em\u003e, with a step size of \u003cem class=\"parameter\"\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e. \u003cem class=\"parameter\"\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e defaults to 1.","description_zh":"从 start 到 stop 生成一系列的值，步长为 step。step 默认为 1。","description_zh_html":"从 \u003cem class=\"parameter\"\u003e\u003ccode\u003estart\u003c/code\u003e\u003c/em\u003e 到 \u003cem class=\"parameter\"\u003e\u003ccode\u003estop\u003c/code\u003e\u003c/em\u003e 生成一系列的值，步长为 \u003cem class=\"parameter\"\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e。\u003cem class=\"parameter\"\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e 默认为 1。","examples":[],"html":"\u003ccode class=\"function\"\u003egenerate_series\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003estart\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003ebigint\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003estop\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003ebigint\u003c/code\u003e [\u003cspan class=\"optional\"\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003ebigint\u003c/code\u003e\u003c/span\u003e ] ) → \u003ccode class=\"returnvalue\"\u003esetof bigint\u003c/code\u003e","returns":"setof bigint","text":"generate_series ( start bigint, stop bigint [, step bigint ] ) → setof bigint","zh_from":"same-version-pgdoc"},{"description":"Generates a series of values from start to stop, with a step size of step. step defaults to 1.","description_html":"Generates a series of values from \u003cem class=\"parameter\"\u003e\u003ccode\u003estart\u003c/code\u003e\u003c/em\u003e to \u003cem class=\"parameter\"\u003e\u003ccode\u003estop\u003c/code\u003e\u003c/em\u003e, with a step size of \u003cem class=\"parameter\"\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e. \u003cem class=\"parameter\"\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e defaults to 1.","description_zh":"从 start 到 stop 生成一系列的值，步长为 step。step 默认为 1。","description_zh_html":"从 \u003cem class=\"parameter\"\u003e\u003ccode\u003estart\u003c/code\u003e\u003c/em\u003e 到 \u003cem class=\"parameter\"\u003e\u003ccode\u003estop\u003c/code\u003e\u003c/em\u003e 生成一系列的值，步长为 \u003cem class=\"parameter\"\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e。\u003cem class=\"parameter\"\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e 默认为 1。","examples":[],"html":"\u003ccode class=\"function\"\u003egenerate_series\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003estart\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003enumeric\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003estop\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003enumeric\u003c/code\u003e [\u003cspan class=\"optional\"\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003enumeric\u003c/code\u003e\u003c/span\u003e ] ) → \u003ccode class=\"returnvalue\"\u003esetof numeric\u003c/code\u003e","returns":"setof numeric","text":"generate_series ( start numeric, stop numeric [, step numeric ] ) → setof numeric","zh_from":"same-version-pgdoc"},{"description":"Generates a series of values from start to stop, with a step size of step. In the timezone-aware form, times of day and daylight-savings adjustments are computed according to the time zone named by the timezone argument, or the current TimeZone setting if that is omitted.","description_html":"Generates a series of values from \u003cem class=\"parameter\"\u003e\u003ccode\u003estart\u003c/code\u003e\u003c/em\u003e to \u003cem class=\"parameter\"\u003e\u003ccode\u003estop\u003c/code\u003e\u003c/em\u003e, with a step size of \u003cem class=\"parameter\"\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e. In the timezone-aware form, times of day and daylight-savings adjustments are computed according to the time zone named by the \u003cem class=\"parameter\"\u003e\u003ccode\u003etimezone\u003c/code\u003e\u003c/em\u003e argument, or the current \u003ca href=\"/docs/18/runtime-config-client.html#GUC-TIMEZONE\"\u003eTimeZone\u003c/a\u003e setting if that is omitted.","description_zh":"从 start 到 stop 生成一系列的值，步长为 step。在带时区形式中，一天中的时刻以及夏令时调整会根据 timezone 参数指定的时区来计算；如果省略该参数，则使用当前的 TimeZone 设置。","description_zh_html":"从 \u003cem class=\"parameter\"\u003e\u003ccode\u003estart\u003c/code\u003e\u003c/em\u003e 到 \u003cem class=\"parameter\"\u003e\u003ccode\u003estop\u003c/code\u003e\u003c/em\u003e 生成一系列的值，步长为 \u003cem class=\"parameter\"\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e。在带时区形式中，一天中的时刻以及夏令时调整会根据 \u003cem class=\"parameter\"\u003e\u003ccode\u003etimezone\u003c/code\u003e\u003c/em\u003e 参数指定的时区来计算；如果省略该参数，则使用当前的 \u003ca href=\"/zh/docs/18/runtime-config-client.html#GUC-TIMEZONE\"\u003eTimeZone\u003c/a\u003e 设置。","examples":[],"html":"\u003ccode class=\"function\"\u003egenerate_series\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003estart\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etimestamp\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003estop\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etimestamp\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003einterval\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003esetof timestamp\u003c/code\u003e","returns":"setof timestamp","text":"generate_series ( start timestamp, stop timestamp, step interval ) → setof timestamp","zh_from":"same-version-pgdoc"},{"description":"Generates a series of values from start to stop, with a step size of step. In the timezone-aware form, times of day and daylight-savings adjustments are computed according to the time zone named by the timezone argument, or the current TimeZone setting if that is omitted.","description_html":"Generates a series of values from \u003cem class=\"parameter\"\u003e\u003ccode\u003estart\u003c/code\u003e\u003c/em\u003e to \u003cem class=\"parameter\"\u003e\u003ccode\u003estop\u003c/code\u003e\u003c/em\u003e, with a step size of \u003cem class=\"parameter\"\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e. In the timezone-aware form, times of day and daylight-savings adjustments are computed according to the time zone named by the \u003cem class=\"parameter\"\u003e\u003ccode\u003etimezone\u003c/code\u003e\u003c/em\u003e argument, or the current \u003ca href=\"/docs/18/runtime-config-client.html#GUC-TIMEZONE\"\u003eTimeZone\u003c/a\u003e setting if that is omitted.","description_zh":"从 start 到 stop 生成一系列的值，步长为 step。在带时区形式中，一天中的时刻以及夏令时调整会根据 timezone 参数指定的时区来计算；如果省略该参数，则使用当前的 TimeZone 设置。","description_zh_html":"从 \u003cem class=\"parameter\"\u003e\u003ccode\u003estart\u003c/code\u003e\u003c/em\u003e 到 \u003cem class=\"parameter\"\u003e\u003ccode\u003estop\u003c/code\u003e\u003c/em\u003e 生成一系列的值，步长为 \u003cem class=\"parameter\"\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e。在带时区形式中，一天中的时刻以及夏令时调整会根据 \u003cem class=\"parameter\"\u003e\u003ccode\u003etimezone\u003c/code\u003e\u003c/em\u003e 参数指定的时区来计算；如果省略该参数，则使用当前的 \u003ca href=\"/zh/docs/18/runtime-config-client.html#GUC-TIMEZONE\"\u003eTimeZone\u003c/a\u003e 设置。","examples":[],"html":"\u003ccode class=\"function\"\u003egenerate_series\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003estart\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etimestamp with time zone\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003estop\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etimestamp with time zone\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003einterval\u003c/code\u003e [\u003cspan class=\"optional\"\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003etimezone\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etext\u003c/code\u003e\u003c/span\u003e ] ) → \u003ccode class=\"returnvalue\"\u003esetof timestamp with time zone\u003c/code\u003e","returns":"setof timestamp with time zone","text":"generate_series ( start timestamp with time zone, stop timestamp with time zone, step interval [, timezone text ] ) → setof timestamp with time zone","zh_from":"same-version-pgdoc"}],"translation_provenance":{"inputs":[{"kind":"current-pgdoc-translation","path":"/Users/vonng/pgsty/pgdoc/zh/18/html/functions-srf.html","sha256":"8002045bb1c73c8c782efc32ceb366c8f004b43469e39ec91ba7b35d2f28507b"}],"kind":"same-version-pgdoc","locale":"zh-Hans","source_revision":"b1b500221dbe5437cfca004d6b04d3f6e422765d","version":"18"},"zh_from":"same-version-pgdoc"},"ManualEvidence":{"doc":{"anchor":"FUNCTIONS-SRF-SERIES","file":"functions-srf.html","slug":"18"}},"MeasuredEvidence":{}},"Text":{"Collection":"func","Key":"generate-series","SourceDatabase":"center","Version":"18","Locale":"en","Title":"generate_series","Summary":"Generates a series of values from start to stop, with a step size of step. step defaults to 1.","BodyHTML":"Generates a series of values from \u003cem\u003e\u003ccode\u003estart\u003c/code\u003e\u003c/em\u003e to \u003cem\u003e\u003ccode\u003estop\u003c/code\u003e\u003c/em\u003e, with a step size of \u003cem\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e. \u003cem\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e defaults to 1.","SourceRevision":"wiki-repair-20261023:1c2304e30569a0aebdaeba0dd4c7971094d93c08102f5e19dbbab56207d69e79","ContentHash":"a1d35b31bb6af8ab3ca32de0e8d46af4cc869d9a43accb5ebd2b783d61fdb197","Payload":{"description":"Generates a series of values from start to stop, with a step size of step. step defaults to 1.","description_html":"Generates a series of values from \u003cem class=\"parameter\"\u003e\u003ccode\u003estart\u003c/code\u003e\u003c/em\u003e to \u003cem class=\"parameter\"\u003e\u003ccode\u003estop\u003c/code\u003e\u003c/em\u003e, with a step size of \u003cem class=\"parameter\"\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e. \u003cem class=\"parameter\"\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e defaults to 1.","signatures":[{"description":"Generates a series of values from start to stop, with a step size of step. step defaults to 1.","description_html":"Generates a series of values from \u003cem class=\"parameter\"\u003e\u003ccode\u003estart\u003c/code\u003e\u003c/em\u003e to \u003cem class=\"parameter\"\u003e\u003ccode\u003estop\u003c/code\u003e\u003c/em\u003e, with a step size of \u003cem class=\"parameter\"\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e. \u003cem class=\"parameter\"\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e defaults to 1.","description_zh":"从 start 到 stop 生成一系列的值，步长为 step。step 默认为 1。","description_zh_html":"从 \u003cem class=\"parameter\"\u003e\u003ccode\u003estart\u003c/code\u003e\u003c/em\u003e 到 \u003cem class=\"parameter\"\u003e\u003ccode\u003estop\u003c/code\u003e\u003c/em\u003e 生成一系列的值，步长为 \u003cem class=\"parameter\"\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e。\u003cem class=\"parameter\"\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e 默认为 1。","examples":[],"html":"\u003ccode class=\"function\"\u003egenerate_series\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003estart\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003einteger\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003estop\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003einteger\u003c/code\u003e [\u003cspan class=\"optional\"\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003einteger\u003c/code\u003e\u003c/span\u003e ] ) → \u003ccode class=\"returnvalue\"\u003esetof integer\u003c/code\u003e","returns":"setof integer","text":"generate_series ( start integer, stop integer [, step integer ] ) → setof integer","zh_from":"same-version-pgdoc"},{"description":"Generates a series of values from start to stop, with a step size of step. step defaults to 1.","description_html":"Generates a series of values from \u003cem class=\"parameter\"\u003e\u003ccode\u003estart\u003c/code\u003e\u003c/em\u003e to \u003cem class=\"parameter\"\u003e\u003ccode\u003estop\u003c/code\u003e\u003c/em\u003e, with a step size of \u003cem class=\"parameter\"\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e. \u003cem class=\"parameter\"\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e defaults to 1.","description_zh":"从 start 到 stop 生成一系列的值，步长为 step。step 默认为 1。","description_zh_html":"从 \u003cem class=\"parameter\"\u003e\u003ccode\u003estart\u003c/code\u003e\u003c/em\u003e 到 \u003cem class=\"parameter\"\u003e\u003ccode\u003estop\u003c/code\u003e\u003c/em\u003e 生成一系列的值，步长为 \u003cem class=\"parameter\"\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e。\u003cem class=\"parameter\"\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e 默认为 1。","examples":[],"html":"\u003ccode class=\"function\"\u003egenerate_series\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003estart\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003ebigint\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003estop\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003ebigint\u003c/code\u003e [\u003cspan class=\"optional\"\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003ebigint\u003c/code\u003e\u003c/span\u003e ] ) → \u003ccode class=\"returnvalue\"\u003esetof bigint\u003c/code\u003e","returns":"setof bigint","text":"generate_series ( start bigint, stop bigint [, step bigint ] ) → setof bigint","zh_from":"same-version-pgdoc"},{"description":"Generates a series of values from start to stop, with a step size of step. step defaults to 1.","description_html":"Generates a series of values from \u003cem class=\"parameter\"\u003e\u003ccode\u003estart\u003c/code\u003e\u003c/em\u003e to \u003cem class=\"parameter\"\u003e\u003ccode\u003estop\u003c/code\u003e\u003c/em\u003e, with a step size of \u003cem class=\"parameter\"\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e. \u003cem class=\"parameter\"\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e defaults to 1.","description_zh":"从 start 到 stop 生成一系列的值，步长为 step。step 默认为 1。","description_zh_html":"从 \u003cem class=\"parameter\"\u003e\u003ccode\u003estart\u003c/code\u003e\u003c/em\u003e 到 \u003cem class=\"parameter\"\u003e\u003ccode\u003estop\u003c/code\u003e\u003c/em\u003e 生成一系列的值，步长为 \u003cem class=\"parameter\"\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e。\u003cem class=\"parameter\"\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e 默认为 1。","examples":[],"html":"\u003ccode class=\"function\"\u003egenerate_series\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003estart\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003enumeric\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003estop\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003enumeric\u003c/code\u003e [\u003cspan class=\"optional\"\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003enumeric\u003c/code\u003e\u003c/span\u003e ] ) → \u003ccode class=\"returnvalue\"\u003esetof numeric\u003c/code\u003e","returns":"setof numeric","text":"generate_series ( start numeric, stop numeric [, step numeric ] ) → setof numeric","zh_from":"same-version-pgdoc"},{"description":"Generates a series of values from start to stop, with a step size of step. In the timezone-aware form, times of day and daylight-savings adjustments are computed according to the time zone named by the timezone argument, or the current TimeZone setting if that is omitted.","description_html":"Generates a series of values from \u003cem class=\"parameter\"\u003e\u003ccode\u003estart\u003c/code\u003e\u003c/em\u003e to \u003cem class=\"parameter\"\u003e\u003ccode\u003estop\u003c/code\u003e\u003c/em\u003e, with a step size of \u003cem class=\"parameter\"\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e. In the timezone-aware form, times of day and daylight-savings adjustments are computed according to the time zone named by the \u003cem class=\"parameter\"\u003e\u003ccode\u003etimezone\u003c/code\u003e\u003c/em\u003e argument, or the current \u003ca href=\"/docs/18/runtime-config-client.html#GUC-TIMEZONE\"\u003eTimeZone\u003c/a\u003e setting if that is omitted.","description_zh":"从 start 到 stop 生成一系列的值，步长为 step。在带时区形式中，一天中的时刻以及夏令时调整会根据 timezone 参数指定的时区来计算；如果省略该参数，则使用当前的 TimeZone 设置。","description_zh_html":"从 \u003cem class=\"parameter\"\u003e\u003ccode\u003estart\u003c/code\u003e\u003c/em\u003e 到 \u003cem class=\"parameter\"\u003e\u003ccode\u003estop\u003c/code\u003e\u003c/em\u003e 生成一系列的值，步长为 \u003cem class=\"parameter\"\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e。在带时区形式中，一天中的时刻以及夏令时调整会根据 \u003cem class=\"parameter\"\u003e\u003ccode\u003etimezone\u003c/code\u003e\u003c/em\u003e 参数指定的时区来计算；如果省略该参数，则使用当前的 \u003ca href=\"/zh/docs/18/runtime-config-client.html#GUC-TIMEZONE\"\u003eTimeZone\u003c/a\u003e 设置。","examples":[],"html":"\u003ccode class=\"function\"\u003egenerate_series\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003estart\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etimestamp\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003estop\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etimestamp\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003einterval\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003esetof timestamp\u003c/code\u003e","returns":"setof timestamp","text":"generate_series ( start timestamp, stop timestamp, step interval ) → setof timestamp","zh_from":"same-version-pgdoc"},{"description":"Generates a series of values from start to stop, with a step size of step. In the timezone-aware form, times of day and daylight-savings adjustments are computed according to the time zone named by the timezone argument, or the current TimeZone setting if that is omitted.","description_html":"Generates a series of values from \u003cem class=\"parameter\"\u003e\u003ccode\u003estart\u003c/code\u003e\u003c/em\u003e to \u003cem class=\"parameter\"\u003e\u003ccode\u003estop\u003c/code\u003e\u003c/em\u003e, with a step size of \u003cem class=\"parameter\"\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e. In the timezone-aware form, times of day and daylight-savings adjustments are computed according to the time zone named by the \u003cem class=\"parameter\"\u003e\u003ccode\u003etimezone\u003c/code\u003e\u003c/em\u003e argument, or the current \u003ca href=\"/docs/18/runtime-config-client.html#GUC-TIMEZONE\"\u003eTimeZone\u003c/a\u003e setting if that is omitted.","description_zh":"从 start 到 stop 生成一系列的值，步长为 step。在带时区形式中，一天中的时刻以及夏令时调整会根据 timezone 参数指定的时区来计算；如果省略该参数，则使用当前的 TimeZone 设置。","description_zh_html":"从 \u003cem class=\"parameter\"\u003e\u003ccode\u003estart\u003c/code\u003e\u003c/em\u003e 到 \u003cem class=\"parameter\"\u003e\u003ccode\u003estop\u003c/code\u003e\u003c/em\u003e 生成一系列的值，步长为 \u003cem class=\"parameter\"\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e。在带时区形式中，一天中的时刻以及夏令时调整会根据 \u003cem class=\"parameter\"\u003e\u003ccode\u003etimezone\u003c/code\u003e\u003c/em\u003e 参数指定的时区来计算；如果省略该参数，则使用当前的 \u003ca href=\"/zh/docs/18/runtime-config-client.html#GUC-TIMEZONE\"\u003eTimeZone\u003c/a\u003e 设置。","examples":[],"html":"\u003ccode class=\"function\"\u003egenerate_series\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003estart\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etimestamp with time zone\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003estop\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etimestamp with time zone\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003einterval\u003c/code\u003e [\u003cspan class=\"optional\"\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003etimezone\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etext\u003c/code\u003e\u003c/span\u003e ] ) → \u003ccode class=\"returnvalue\"\u003esetof timestamp with time zone\u003c/code\u003e","returns":"setof timestamp with time zone","text":"generate_series ( start timestamp with time zone, stop timestamp with time zone, step interval [, timezone text ] ) → setof timestamp with time zone","zh_from":"same-version-pgdoc"}]}},"RequestedLocale":"en","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20","8.0","8.1","8.2","8.3","8.4","9.0","9.1","9.2","9.3","9.4","9.5","9.6"],"Locales":["en","zh-Hans"],"Signatures":[{"Version":"18","Ordinal":0,"Hash":"201529b78288920dd90809587d9fc1c2e3ccc028af70b2c8f57ad2e1f1af5c56","Text":"generate_series ( start integer, stop integer [, step integer ] ) → setof integer","Returns":"setof integer","Payload":{"description":"Generates a series of values from start to stop, with a step size of step. step defaults to 1.","description_html":"Generates a series of values from \u003cem class=\"parameter\"\u003e\u003ccode\u003estart\u003c/code\u003e\u003c/em\u003e to \u003cem class=\"parameter\"\u003e\u003ccode\u003estop\u003c/code\u003e\u003c/em\u003e, with a step size of \u003cem class=\"parameter\"\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e. \u003cem class=\"parameter\"\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e defaults to 1.","description_zh":"从 start 到 stop 生成一系列的值，步长为 step。step 默认为 1。","description_zh_html":"从 \u003cem class=\"parameter\"\u003e\u003ccode\u003estart\u003c/code\u003e\u003c/em\u003e 到 \u003cem class=\"parameter\"\u003e\u003ccode\u003estop\u003c/code\u003e\u003c/em\u003e 生成一系列的值，步长为 \u003cem class=\"parameter\"\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e。\u003cem class=\"parameter\"\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e 默认为 1。","examples":[],"html":"\u003ccode class=\"function\"\u003egenerate_series\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003estart\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003einteger\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003estop\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003einteger\u003c/code\u003e [\u003cspan class=\"optional\"\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003einteger\u003c/code\u003e\u003c/span\u003e ] ) → \u003ccode class=\"returnvalue\"\u003esetof integer\u003c/code\u003e","returns":"setof integer","text":"generate_series ( start integer, stop integer [, step integer ] ) → setof integer","zh_from":"same-version-pgdoc"}},{"Version":"18","Ordinal":1,"Hash":"c47758eb3dd7d83d091bc1cff5d9974ccf8f9fdc03cd2390c439049b94259c28","Text":"generate_series ( start bigint, stop bigint [, step bigint ] ) → setof bigint","Returns":"setof bigint","Payload":{"description":"Generates a series of values from start to stop, with a step size of step. step defaults to 1.","description_html":"Generates a series of values from \u003cem class=\"parameter\"\u003e\u003ccode\u003estart\u003c/code\u003e\u003c/em\u003e to \u003cem class=\"parameter\"\u003e\u003ccode\u003estop\u003c/code\u003e\u003c/em\u003e, with a step size of \u003cem class=\"parameter\"\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e. \u003cem class=\"parameter\"\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e defaults to 1.","description_zh":"从 start 到 stop 生成一系列的值，步长为 step。step 默认为 1。","description_zh_html":"从 \u003cem class=\"parameter\"\u003e\u003ccode\u003estart\u003c/code\u003e\u003c/em\u003e 到 \u003cem class=\"parameter\"\u003e\u003ccode\u003estop\u003c/code\u003e\u003c/em\u003e 生成一系列的值，步长为 \u003cem class=\"parameter\"\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e。\u003cem class=\"parameter\"\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e 默认为 1。","examples":[],"html":"\u003ccode class=\"function\"\u003egenerate_series\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003estart\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003ebigint\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003estop\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003ebigint\u003c/code\u003e [\u003cspan class=\"optional\"\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003ebigint\u003c/code\u003e\u003c/span\u003e ] ) → \u003ccode class=\"returnvalue\"\u003esetof bigint\u003c/code\u003e","returns":"setof bigint","text":"generate_series ( start bigint, stop bigint [, step bigint ] ) → setof bigint","zh_from":"same-version-pgdoc"}},{"Version":"18","Ordinal":2,"Hash":"c3726d730745e3a5ed4bb462ac1c39ca527ab9fc299b093c7ff1d68af3b57a66","Text":"generate_series ( start numeric, stop numeric [, step numeric ] ) → setof numeric","Returns":"setof numeric","Payload":{"description":"Generates a series of values from start to stop, with a step size of step. step defaults to 1.","description_html":"Generates a series of values from \u003cem class=\"parameter\"\u003e\u003ccode\u003estart\u003c/code\u003e\u003c/em\u003e to \u003cem class=\"parameter\"\u003e\u003ccode\u003estop\u003c/code\u003e\u003c/em\u003e, with a step size of \u003cem class=\"parameter\"\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e. \u003cem class=\"parameter\"\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e defaults to 1.","description_zh":"从 start 到 stop 生成一系列的值，步长为 step。step 默认为 1。","description_zh_html":"从 \u003cem class=\"parameter\"\u003e\u003ccode\u003estart\u003c/code\u003e\u003c/em\u003e 到 \u003cem class=\"parameter\"\u003e\u003ccode\u003estop\u003c/code\u003e\u003c/em\u003e 生成一系列的值，步长为 \u003cem class=\"parameter\"\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e。\u003cem class=\"parameter\"\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e 默认为 1。","examples":[],"html":"\u003ccode class=\"function\"\u003egenerate_series\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003estart\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003enumeric\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003estop\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003enumeric\u003c/code\u003e [\u003cspan class=\"optional\"\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003enumeric\u003c/code\u003e\u003c/span\u003e ] ) → \u003ccode class=\"returnvalue\"\u003esetof numeric\u003c/code\u003e","returns":"setof numeric","text":"generate_series ( start numeric, stop numeric [, step numeric ] ) → setof numeric","zh_from":"same-version-pgdoc"}},{"Version":"18","Ordinal":3,"Hash":"aa9ef42d8ddc9aee6679c54f4953fef4ddc321629abf0e2bdc8f4935baf212da","Text":"generate_series ( start timestamp, stop timestamp, step interval ) → setof timestamp","Returns":"setof timestamp","Payload":{"description":"Generates a series of values from start to stop, with a step size of step. In the timezone-aware form, times of day and daylight-savings adjustments are computed according to the time zone named by the timezone argument, or the current TimeZone setting if that is omitted.","description_html":"Generates a series of values from \u003cem class=\"parameter\"\u003e\u003ccode\u003estart\u003c/code\u003e\u003c/em\u003e to \u003cem class=\"parameter\"\u003e\u003ccode\u003estop\u003c/code\u003e\u003c/em\u003e, with a step size of \u003cem class=\"parameter\"\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e. In the timezone-aware form, times of day and daylight-savings adjustments are computed according to the time zone named by the \u003cem class=\"parameter\"\u003e\u003ccode\u003etimezone\u003c/code\u003e\u003c/em\u003e argument, or the current \u003ca href=\"/docs/18/runtime-config-client.html#GUC-TIMEZONE\"\u003eTimeZone\u003c/a\u003e setting if that is omitted.","description_zh":"从 start 到 stop 生成一系列的值，步长为 step。在带时区形式中，一天中的时刻以及夏令时调整会根据 timezone 参数指定的时区来计算；如果省略该参数，则使用当前的 TimeZone 设置。","description_zh_html":"从 \u003cem class=\"parameter\"\u003e\u003ccode\u003estart\u003c/code\u003e\u003c/em\u003e 到 \u003cem class=\"parameter\"\u003e\u003ccode\u003estop\u003c/code\u003e\u003c/em\u003e 生成一系列的值，步长为 \u003cem class=\"parameter\"\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e。在带时区形式中，一天中的时刻以及夏令时调整会根据 \u003cem class=\"parameter\"\u003e\u003ccode\u003etimezone\u003c/code\u003e\u003c/em\u003e 参数指定的时区来计算；如果省略该参数，则使用当前的 \u003ca href=\"/zh/docs/18/runtime-config-client.html#GUC-TIMEZONE\"\u003eTimeZone\u003c/a\u003e 设置。","examples":[],"html":"\u003ccode class=\"function\"\u003egenerate_series\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003estart\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etimestamp\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003estop\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etimestamp\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003einterval\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003esetof timestamp\u003c/code\u003e","returns":"setof timestamp","text":"generate_series ( start timestamp, stop timestamp, step interval ) → setof timestamp","zh_from":"same-version-pgdoc"}},{"Version":"18","Ordinal":4,"Hash":"351d713adcf163d91ee7c7795c7b76e4d0fec2902b771262303245df0040e98a","Text":"generate_series ( start timestamp with time zone, stop timestamp with time zone, step interval [, timezone text ] ) → setof timestamp with time zone","Returns":"setof timestamp with time zone","Payload":{"description":"Generates a series of values from start to stop, with a step size of step. In the timezone-aware form, times of day and daylight-savings adjustments are computed according to the time zone named by the timezone argument, or the current TimeZone setting if that is omitted.","description_html":"Generates a series of values from \u003cem class=\"parameter\"\u003e\u003ccode\u003estart\u003c/code\u003e\u003c/em\u003e to \u003cem class=\"parameter\"\u003e\u003ccode\u003estop\u003c/code\u003e\u003c/em\u003e, with a step size of \u003cem class=\"parameter\"\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e. In the timezone-aware form, times of day and daylight-savings adjustments are computed according to the time zone named by the \u003cem class=\"parameter\"\u003e\u003ccode\u003etimezone\u003c/code\u003e\u003c/em\u003e argument, or the current \u003ca href=\"/docs/18/runtime-config-client.html#GUC-TIMEZONE\"\u003eTimeZone\u003c/a\u003e setting if that is omitted.","description_zh":"从 start 到 stop 生成一系列的值，步长为 step。在带时区形式中，一天中的时刻以及夏令时调整会根据 timezone 参数指定的时区来计算；如果省略该参数，则使用当前的 TimeZone 设置。","description_zh_html":"从 \u003cem class=\"parameter\"\u003e\u003ccode\u003estart\u003c/code\u003e\u003c/em\u003e 到 \u003cem class=\"parameter\"\u003e\u003ccode\u003estop\u003c/code\u003e\u003c/em\u003e 生成一系列的值，步长为 \u003cem class=\"parameter\"\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e。在带时区形式中，一天中的时刻以及夏令时调整会根据 \u003cem class=\"parameter\"\u003e\u003ccode\u003etimezone\u003c/code\u003e\u003c/em\u003e 参数指定的时区来计算；如果省略该参数，则使用当前的 \u003ca href=\"/zh/docs/18/runtime-config-client.html#GUC-TIMEZONE\"\u003eTimeZone\u003c/a\u003e 设置。","examples":[],"html":"\u003ccode class=\"function\"\u003egenerate_series\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003estart\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etimestamp with time zone\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003estop\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etimestamp with time zone\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003einterval\u003c/code\u003e [\u003cspan class=\"optional\"\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003etimezone\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etext\u003c/code\u003e\u003c/span\u003e ] ) → \u003ccode class=\"returnvalue\"\u003esetof timestamp with time zone\u003c/code\u003e","returns":"setof timestamp with time zone","text":"generate_series ( start timestamp with time zone, stop timestamp with time zone, step interval [, timezone text ] ) → setof timestamp with time zone","zh_from":"same-version-pgdoc"}}],"Spellings":null,"SQLState":null,"Evidence":null}