Skip to content

PREPARE, EXECUTE and DEALLOCATE are not top-level statements #242

Closed

Description

@silathdiir

Hi, I am using this crate to parse SQLs, and working on Postgres Extended Query. e.g.

prepare stmt (smallint) AS select * from schema_name.table_name where si_column_2 = $1;
execute stmt(1, 2);
deallocate stmt;

I tried to find solutions by Dialect, but it seems that PREPARE, EXECUTE and DEALLOCATE are not top-level statements.

Should they be added as top-level statements? Or there are other better solutions. Thanks.

Activity

  1. nickolay commented on Jul 27, 2020

    @nickolay
    Contributor

    Yes, adding them as new Statement variants is how we do that. Please note that it's Postgres-specific syntax in the comments.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    help wantedExtra attention is needed

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions