Choose your SQL server:
AnySQL
MySQL
MS SQL Server
PostgreSQL
Oracle
SQL Anywhere
DB2
SQLite
Firebird
MaxDB

Subscribe to our newsletter

PostgreSQL Maestro online Help

Prev  Return to chapter overview Next 

Specifying cast properties

Specify cast options according to your needs. The detailed description is given below.

 

Comment

The box allows you to set optional text to describe the new cast.

 

Source Type

Specify the name of the source data type of the cast.

 

Target Type

Set the name of the target data type of the cast.

 

Function

The function used to perform the cast. The function name may be schema-qualified. If it is not, the function will be looked up in the schema search path. The function result data type must match the target type of the cast. Specify no function to indicate that no function is required to perform the cast.

 

Context (Assignment, Implicit, Explicit)

Assignment indicates that the cast may be invoked implicitly in assignment contexts. Implicit indicates that the cast may be invoked implicitly in any context. By default, a cast can be invoked only by an Explicit cast.

 

Note: Remember that if you want to be able to convert types both ways you need to declare casts both ways explicitly.



Prev  Return to chapter overview Next