{"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","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"],"signature":"generate_series ( start integer, stop integer [, step integer ] ) → setof integer","signature_count":5,"slug":"generate-series","source_rev":"b7bd9cda","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":"b7bd9cda","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":"","description_zh_html":"","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":"","description_zh_html":"","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":""},{"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":"","description_zh_html":"","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":""},{"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":"","description_zh_html":"","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":""},{"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":"","description_zh_html":"","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":""},{"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":"","description_zh_html":"","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":""}],"zh_from":""},"ManualEvidence":{"doc":{"anchor":"FUNCTIONS-SRF-SERIES","file":"functions-srf.html","slug":"18"}},"MeasuredEvidence":{}},"Text":{"Collection":"func","Key":"generate-series","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"generate_series","Summary":"从start到stop生成一系列的值，步长为step。step默认为1。","BodyHTML":"从\u003cem\u003e\u003ccode\u003estart\u003c/code\u003e\u003c/em\u003e到\u003cem\u003e\u003ccode\u003estop\u003c/code\u003e\u003c/em\u003e生成一系列的值，步长为\u003cem\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e。\u003cem\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e默认为1。\u003cpre\u003egenerate_series ( start integer, stop integer [, step integer ] ) → setof integer\u003c/pre\u003e从\u003cem\u003e\u003ccode\u003estart\u003c/code\u003e\u003c/em\u003e到\u003cem\u003e\u003ccode\u003estop\u003c/code\u003e\u003c/em\u003e生成一系列的值，步长为\u003cem\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e。\u003cem\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e默认为1。\u003cpre\u003egenerate_series ( start bigint, stop bigint [, step bigint ] ) → setof bigint\u003c/pre\u003e从\u003cem\u003e\u003ccode\u003estart\u003c/code\u003e\u003c/em\u003e到\u003cem\u003e\u003ccode\u003estop\u003c/code\u003e\u003c/em\u003e生成一系列的值，步长为\u003cem\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e。\u003cem\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e默认为1。\u003cpre\u003egenerate_series ( start numeric, stop numeric [, step numeric ] ) → setof numeric\u003c/pre\u003e从\u003cem\u003e\u003ccode\u003estart\u003c/code\u003e\u003c/em\u003e到\u003cem\u003e\u003ccode\u003estop\u003c/code\u003e\u003c/em\u003e生成一系列的值，步长为\u003cem\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e。\u003cem\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e默认为1。\u003cpre\u003egenerate_series ( start timestamp, stop timestamp, step interval ) → setof timestamp\u003c/pre\u003e从\u003cem\u003e\u003ccode\u003estart\u003c/code\u003e\u003c/em\u003e到\u003cem\u003e\u003ccode\u003estop\u003c/code\u003e\u003c/em\u003e生成一系列的值，步长为\u003cem\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e。在带时区形式中，一天中的时刻以及夏令时调整会根据\u003cem\u003e\u003ccode\u003etimezone\u003c/code\u003e\u003c/em\u003e参数指定的时区来计算；如果省略该参数，则使用当前的\u003ca href=\"/docs/18/runtime-config-client.html#GUC-TIMEZONE\" rel=\"nofollow\"\u003eTimeZone\u003c/a\u003e设置。\u003cpre\u003egenerate_series ( start timestamp with time zone, stop timestamp with time zone, step interval [, timezone text ] ) → setof timestamp with time zone\u003c/pre\u003e从\u003cem\u003e\u003ccode\u003estart\u003c/code\u003e\u003c/em\u003e到\u003cem\u003e\u003ccode\u003estop\u003c/code\u003e\u003c/em\u003e生成一系列的值，步长为\u003cem\u003e\u003ccode\u003estep\u003c/code\u003e\u003c/em\u003e。在带时区形式中，一天中的时刻以及夏令时调整会根据\u003cem\u003e\u003ccode\u003etimezone\u003c/code\u003e\u003c/em\u003e参数指定的时区来计算；如果省略该参数，则使用当前的\u003ca href=\"/docs/18/runtime-config-client.html#GUC-TIMEZONE\" rel=\"nofollow\"\u003eTimeZone\u003c/a\u003e设置。","SourceRevision":"1b5ca64c","ContentHash":"d21cc799da3de868c696de822f0718abdbc5568ca76b2a5ffb08e2fc2b003faa","Payload":{"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。","signatures":[{"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。","returns":"setof integer","text":"generate_series ( start integer, stop integer [, step integer ] ) → setof integer","zh_from":"doc"},{"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。","returns":"setof bigint","text":"generate_series ( start bigint, stop bigint [, step bigint ] ) → setof bigint","zh_from":"doc"},{"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。","returns":"setof numeric","text":"generate_series ( start numeric, stop numeric [, step numeric ] ) → setof numeric","zh_from":"doc"},{"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=\"/docs/18/runtime-config-client.html#GUC-TIMEZONE\"\u003eTimeZone\u003c/a\u003e设置。","returns":"setof timestamp","text":"generate_series ( start timestamp, stop timestamp, step interval ) → setof timestamp","zh_from":"doc"},{"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=\"/docs/18/runtime-config-client.html#GUC-TIMEZONE\"\u003eTimeZone\u003c/a\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":"doc"}],"zh_from":"doc"}},"RequestedLocale":"zh-Hans","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":"","description_zh_html":"","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":""}},{"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":"","description_zh_html":"","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":""}},{"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":"","description_zh_html":"","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":""}},{"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":"","description_zh_html":"","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":""}},{"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":"","description_zh_html":"","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":""}}],"Spellings":null,"SQLState":null,"Evidence":null}