Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Add support for function endings in dialect postgres #1288

Closed
xamanu opened this issue Aug 16, 2021 · 0 comments · Fixed by #1336
Closed

Add support for function endings in dialect postgres #1288

xamanu opened this issue Aug 16, 2021 · 0 comments · Fixed by #1336
Labels
enhancement New feature or request good first issue Good for newcomers postgres Issues relating to the Postgres dialect

Comments

@xamanu
Copy link

xamanu commented Aug 16, 2021

Defining functions in Postgres and ending the with some typical indications:

[...]
LANGUAGE plpgsql IMMUTABLE PARALLEL SAFE

or variations, such as:

[...]
LANGUAGE plpgsql STABLE PARALLEL SAFE

Executed with

sqlfluff lint --dialect postgres

causes following error:

L:  71 | P:  17 |  PRS | Line 71, Position 17: Found unparsable section: '
                       | IMMUTABLE PARALLEL SAFE'

It would be nice to get this added. Many thanks for the nice linter!
@xamanu xamanu added the enhancement New feature or request label Aug 16, 2021
@xamanu xamanu changed the title Add support for IF NOT EXISTS ... to dialect postgres Add support for function endings in dialect postgres Aug 16, 2021
@tunetheweb tunetheweb added good first issue Good for newcomers postgres Issues relating to the Postgres dialect labels Aug 25, 2021
@WittierDinosaur WittierDinosaur mentioned this issue Aug 30, 2021
Merged
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
enhancement New feature or request good first issue Good for newcomers postgres Issues relating to the Postgres dialect
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

Improve function support in Postgres dialect WittierDinosaur/sqlfluff
2 participants
@xamanu @tunetheweb