PERFORM

Description

This executes a query and discards the result.

Click here to navigate to the PostgreSQL documentation page for this syntax.

The PERFORM is translated to SELECT in Snowflake.

Grammar Syntax

PERFORM query;

Sample Source Patterns

Input

PostgreSQL

PERFORM 'SampleMessage';

PERFORM SampleColumn FROM SampleTable;

PERFORM SampleFunction();

Snowflake

SELECT 'SampleMessage';

SELECT SampleColumn FROM SampleTable;

SELECT SampleFunction();

Known Issues

The SELECT statement does not discard its results but behaves exactly the same as the PERFORM statement in PostgreSQL.

Related EWIs

No related EWIs.