and

Enterprise scalar function reference.

Function Snapshot

Field	Value
Function	and
Category	Numeric and Analytics
Scope	Scalar expression
Discovery	SELECT * FROM pg_catalog.pg_proc WHERE proname = 'and';

Purpose

Executes the scalar function and as registered in the MonkDB scalar function registry.

Syntax

SELECT and(10, 3);

Parameters

• Positional arguments as defined by overload signatures in pg_catalog.pg_proc.

Returns

• Returns function-specific scalar/array/object according to resolved overload.

Null and Error Behavior

• Bit string operands must have equal length; otherwise raises an error.

Operational Notes

• Use schema-qualified objects and parameterized queries for production pipelines.
• Validate overload details in-cluster with pg_catalog.pg_proc and pg_get_function_result(oid).

Cross-References

• Scalar Functions Index
• Scalar Function Discovery
• SQL Functions Overview