GSP
Quick Navigator

Search Site

Unix VPS
A - Starter
B - Basic
C - Preferred
D - Commercial
MPS - Dedicated
Previous VPSs
* Sign Up! *

Support
Contact Us
Online Help
Handbooks
Domain Status
Man Pages

FAQ
Virtual Servers
Pricing
Billing
Technical

Network
Facilities
Connectivity
Topology Map

Miscellaneous
Server Agreement
Year 2038
Credits
 

USA Flag

 

 

Man Pages


Manual Reference Pages  -  DROP_CAST (7)

.ds Aq ’

NAME

DROP_CAST - remove a cast

CONTENTS

SYNOPSIS

DROP CAST [ IF EXISTS ] (source_type AS target_type) [ CASCADE | RESTRICT ]

DESCRIPTION

DROP CAST removes a previously defined cast.

To be able to drop a cast, you must own the source or the target data type. These are the same privileges that are required to create a cast.

PARAMETERS

IF EXISTS

Do not throw an error if the cast does not exist. A notice is issued in this case.

source_type

The name of the source data type of the cast.

target_type

The name of the target data type of the cast.

CASCADE
RESTRICT

These key words do not have any effect, since there are no dependencies on casts.

EXAMPLES

To drop the cast from type text to type int:

DROP CAST (text AS int);

COMPATIBILITY

The DROP CAST command conforms to the SQL standard.

SEE ALSO

CREATE CAST (CREATE_CAST(7))
Search for    or go to Top of page |  Section 7 |  Main Index


PostgreSQL 9.5.2 DROP CAST (7) 2016

Powered by GSP Visit the GSP FreeBSD Man Page Interface.
Output converted with manServer 1.07.