January 2002
Intermediate to advanced
640 pages
16h 39m
English
Content preview from Practical PostgreSQL
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Drop Operator
Removes an operator from the database.
Synopsis
DROP OPERATOR op ( { lefttype | NONE } , { righttype | NONE } )
Parameters
op The operator you wish to remove.
lefttype | NONEThe operator’s left argument type (or
NONE, if it does not have a left argument).righttype | NONEThe operator’s right argument type (or
NONE, if it does not have a right argument).
Results
DROPThe message returned when a user is dropped successfully.
ERROR: RemoveOperator: binary operator 'op' taking 'lefttype' and 'righttype' does not existThe error returned if you specify a binary operator that does not exist.
ERROR: RemoveOperator: left unary operator 'op' taking 'lefttype' does not existThe error returned if you specify a left unary operator that does not exist.
ERROR: RemoveOperator: right unary operator 'op' taking 'righttype' does not existThe error returned if you specify a right unary operator that does not exist.
Description
Use the DROP OPERATOR command to remove an existing operator from the
database. You can only drop an operator if you are the operator’s owner or a superuser.
Note
Removing an operator when there are access methods or operator classes that rely on it can cause problems; be sure you know what elements of your database rely on an operator before dropping it.
Example
The following example drops the binary !# operator for the integer data types:
booktown=# DROP OPERATOR !# (integer, integer); ...Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.