ALTER OPERATOR(7) PostgreSQL 9.2.7 Documentation ALTER OPERATOR(7)NAME
ALTER_OPERATOR - change the definition of an operator
SYNOPSIS
ALTER OPERATOR name ( { left_type | NONE } , { right_type | NONE } ) OWNER TO new_owner
ALTER OPERATOR name ( { left_type | NONE } , { right_type | NONE } ) SET SCHEMA new_schema
DESCRIPTION
ALTER OPERATOR changes the definition of an operator. The only currently available functionality is to change the owner of the operator.
You must own the operator to use ALTER OPERATOR. To alter the owner, you must also be a direct or indirect member of the new owning role,
and that role must have CREATE privilege on the operator's schema. (These restrictions enforce that altering the owner doesn't do anything
you couldn't do by dropping and recreating the operator. However, a superuser can alter ownership of any operator anyway.)
PARAMETERS
name
The name (optionally schema-qualified) of an existing operator.
left_type
The data type of the operator's left operand; write NONE if the operator has no left operand.
right_type
The data type of the operator's right operand; write NONE if the operator has no right operand.
new_owner
The new owner of the operator.
new_schema
The new schema for the operator.
EXAMPLES
Change the owner of a custom operator a @@ b for type text:
ALTER OPERATOR @@ (text, text) OWNER TO joe;
COMPATIBILITY
There is no ALTER OPERATOR statement in the SQL standard.
SEE ALSO
CREATE OPERATOR (CREATE_OPERATOR(7)), DROP OPERATOR (DROP_OPERATOR(7))
PostgreSQL 9.2.7 2014-02-17 ALTER OPERATOR(7)
Check Out this Related Man Page
ALTER OPERATOR(7) SQL Commands ALTER OPERATOR(7)NAME
ALTER OPERATOR - change the definition of an operator
SYNOPSIS
ALTER OPERATOR name ( { lefttype | NONE } , { righttype | NONE } ) OWNER TO newowner
DESCRIPTION
ALTER OPERATOR changes the definition of an operator. The only currently available functionality is to change the owner of the operator.
You must own the operator to use ALTER OPERATOR. To alter the owner, you must also be a direct or indirect member of the new owning role,
and that role must have CREATE privilege on the operator's schema. (These restrictions enforce that altering the owner doesn't do anything
you couldn't do by dropping and recreating the operator. However, a superuser can alter ownership of any operator anyway.)
PARAMETERS
name The name (optionally schema-qualified) of an existing operator.
lefttype
The data type of the operator's left operand; write NONE if the operator has no left operand.
righttype
The data type of the operator's right operand; write NONE if the operator has no right operand.
newowner
The new owner of the operator.
EXAMPLES
Change the owner of a custom operator a @@ b for type text:
ALTER OPERATOR @@ (text, text) OWNER TO joe;
COMPATIBILITY
There is no ALTER OPERATOR statement in the SQL standard.
SEE ALSO
CREATE OPERATOR [create_operator(7)], DROP OPERATOR [drop_operator(7)]
SQL - Language Statements 2010-05-14 ALTER OPERATOR(7)
I need to find out if a variable contains a certain text string, then do something about it.
Here is what I mean, but I don't know how to get a "contains" operator
# We have volumes called:
# /Volumes/BackupsA_K
# /Volumes/BackupsL_Z
# /Volumes/Backups_Admin
# (could be more, etc)... (5 Replies)
Hi,
I have to check whether an argument say $ARGV is not null in an if operator. Please let me know the operator. It would be great if you write a psuedo code.
Thanks in advance
Ammu (4 Replies)
I can't for the life of me remember what the name is for ">"
My mentor told it to me 20 years ago and I can't remember it now. I know we like to call it re-direct, but there was a name othere than that he used.
During a recent training session, someone cut and paste from a file that just happened... (8 Replies)
Hi,
Please clear the 2 questions,
2 Questions,
1) Why the new as a operator? Is there any special reason why it can't be a function like malloc?
2) How are we considering sizeof(),new are as a opearartors? I know + - * / -> , . etc.. are operators, which criteria satisfied by sizeof()... (4 Replies)
I have a need to search for files containing 2 strings as in (AND operator). No one at my site seems to know if it is possible. There is only documentation for the "or' operator.
I know I can do a search, copy all the matched files into a temp directory & do the second search in the temp... (14 Replies)
Dear All,
Good day, Just i would like to know that is there anything called difference operator in awk?
For example, if a file contains 5 columns (as shown below) with both negative and positive values:
Col1 Col2 Col3 Col4 Col5
I need to calculate the difference between Col1 and... (3 Replies)
Hiya all,
Why do I get a :unary operator expected when I try to put a condition statement in my shell script (sh) like so and how to fix?
if ; then
echo "say hello"
else
echo "don't say hello"
fi
? It seems if the script receives an argument it works but if I don't put an... (4 Replies)
Hey all. I've been working on some fun with C and decided to write a Rock Paper Scissors game. The problem is, that when I try to compile the file, it gives "lvalue required as left operand of assignment" error. The error line is here:
for ((point1=0 && point2=0); ((point1=3) || (point2=3));... (4 Replies)
I was trying to figure out how to write a shell script to be able to print the name of the file and size to a text file I wanted to know if I was on the right track and am understanding this better.
In my script a for loop be able to print files over 4mb (we charge differently for larger images)... (18 Replies)
Hi,
I was hoping someone could explain this please :)
I'm using bash, scientific linux... and I don't know what else you need to know. With
awk '{ if( 0.3 == 0.1*3) print $1}' file.dat
nothing will be printed since apparently the two numbers do not equate. (Using 0.3 != 0.1*3 is seen... (4 Replies)
Hey all,
I not able to find it what -n stand operator stands for.
] && print -u2 "ERROR: $*"
could you please let me know why we are using -n in the code. (15 Replies)
Hi,
I'm new to the Ash shell so my apologies if this is well known. In normal maths and other shells and languages I've used, the modulo operator always returns a positive remainder. For example see this discussion (first post so I can't hyperlink it):
... (11 Replies)
how can i use like operator in IF statement. Below is correct format, please guide
if ; then
CT_ACT_FILE_NAME=`echo FINACLE'
else
CT_ACT_FILE_NAME=`echo not listed'
fi
---------- Post updated at 04:58 PM ---------- Previous update was at 04:56 PM ----------
Please use CODE... (6 Replies)
Hello. I'm self teaching myself and coded a program but I keep getting a illegal division by 0 error. I know what it means but I don't know where I am messing up.
Here is the code:
#!/usr/bin/perl
@lines = <>;
my %earned;
my %possible;
for ($i = 1; $i <... (6 Replies)