Comments (2)
PostgreSQL: Documentation: 16: CREATE FUNCTION
CREATE [ OR REPLACE ] FUNCTION
name ( [ [ argmode ] [ argname ] argtype [ { DEFAULT | = } default_expr ] [, ...] ] )
[ RETURNS rettype
| RETURNS TABLE ( column_name column_type [, ...] ) ]
{ LANGUAGE lang_name
| TRANSFORM { FOR TYPE type_name } [, ... ]
| WINDOW
| { IMMUTABLE | STABLE | VOLATILE }
| [ NOT ] LEAKPROOF
| { CALLED ON NULL INPUT | RETURNS NULL ON NULL INPUT | STRICT }
| { [ EXTERNAL ] SECURITY INVOKER | [ EXTERNAL ] SECURITY DEFINER }
| PARALLEL { UNSAFE | RESTRICTED | SAFE }
| COST execution_cost
| ROWS result_rows
| SUPPORT support_function
| SET configuration_parameter { TO value | = value | FROM CURRENT }
| AS 'definition'
| AS 'obj_file', 'link_symbol'
| sql_body
} ...
Here -> | SET configuration_parameter { TO value | = value | FROM CURRENT }
from atlas.
Note: It is important to mention that FROM CURRENT
does not always refer to the actual current session state. Unfortunately, it refers to the state at the time the CREATE FUNCTION
command is executed. Despite this limitation, using the syntax like SET lock_timeout TO '0'
is still very meaningful, and therefore, I strongly request that this syntax be supported at a minimum.
from atlas.
Related Issues (20)
- Feature Request: Support for Clickhouse Dictionary
- Bypass interactive approval for column `RENAME` detection HOT 5
- Hard to keep HCL files concise when they contain same table names
- What is the HCL standard library? Is this documented anywhere? HOT 1
- Linter for versioned workflow doesn't follow transaction model
- Latest release makes diff command fail
- Feature Request: Add support of SSH tunnel
- Missing Schema Prefix in DDL `RENAME` Statement HOT 4
- [REOPEN of #3006] Missing Schema Prefix in DDL `RENAME`
- Atlas hash incorrect order for golang migrate
- Fix the URL parsing for special characters. HOT 2
- Running atlas commands against cockroachdb returns error with postgres wire protocol HOT 2
- Add Postgres 15+ support for security = INVOKER
- Declarative workflow breaks on YugabyteDB HOT 6
- Atlas HCL Syntax: String Not Recognized by Linter HOT 5
- [Multi-file schema]: Allow glob pattern for `env.src` HOT 2
- [Multi-file schema / vsCode extension]: Load related schema files into extension context HOT 5
- [vsCode extension]: Do not require schema files to end in `.pg.hcl` HOT 1
- Go 1.23 support with ent schema loader HOT 4
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from atlas.