Skip to content

PgSqlFunctionProviderAttribute

Namespace: Ankus

Assembly: Ankus.Runtime.dll

Declares a function created by a custom SQL block for named selection and extension attachment.

[AttributeUsage(AttributeTargets.Assembly, AllowMultiple = true)]
public sealed class PgSqlFunctionProviderAttribute : Attribute

The signature is authored SQL, such as app.calculate(integer, text), and must identify an existing function after the block runs. Use explicit schema qualification when the block installs into a fixed schema. PostgreSQL validates the signature when executing the selected script.

Inheritance: object, Attribute

PgSqlFunctionProviderAttribute(string, string)

Section titled “PgSqlFunctionProviderAttribute(string, string)”

Declares a function created by a custom SQL block for named selection and extension attachment.

public PgSqlFunctionProviderAttribute(string sqlId, string signature)

Parameters:

sqlId — string

The identifier of a PgSql or PgSqlFile block.

signature — string

The SQL function name and argument type list, without a FUNCTION keyword.

The signature is authored SQL, such as app.calculate(integer, text), and must identify an existing function after the block runs. Use explicit schema qualification when the block installs into a fixed schema. PostgreSQL validates the signature when executing the selected script.

Gets the authored SQL identity used after ALTER EXTENSION ADD FUNCTION.

public string Signature { get; }

Value: string

Gets the identifier of the block that creates the function.

public string SqlId { get; }

Value: string