09-21-2004
Ah well, teach me to pay attention to which forum topic I'm in when I post I guess. Will type them out again later.
Thanks for letting me know.
Mark.
8 More Discussions You Might Find Interesting
1. Post Here to Contact Site Administrators and Moderators
A few hours ago I made several reasonable posts to this forum and now they have dissapeared.
I read and followed the rules, and I sure didn't break any, but gone they are :(
I know I only joined the forum today, but do the posts have to be authorised or something?
... (14 Replies)
Discussion started by: cw1972
14 Replies
2. UNIX for Dummies Questions & Answers
Ahhhh!!!!!!!!
All of my user accounts can no longer login. I suspected a corrupt passwd file, but everything looks OK and the passwd file works when I copy it to another system. All user accounts cannot login...they recieve a "No directory defined" error, but I can logon using root just fine. I... (13 Replies)
Discussion started by: jskillet
13 Replies
3. What is on Your Mind?
:D anyone hear from ygor..?
haven't seen him post in a while... wonder what he is up to..!
the last i heard he was the D25khan.. that was him right guys ???
being a newbie myself that is one dude that i admire. him Norsk, Perdebro, RTM , Google and Zazzybob all real genius.. and the most... (2 Replies)
Discussion started by: moxxx68
2 Replies
4. Shell Programming and Scripting
The second script seems not to work. (3 Replies)
Discussion started by: endeavour1985
3 Replies
5. UNIX for Dummies Questions & Answers
I've been using a mkisofs line like this for years without problem
# mkisofs -J -R -V 'Vol Label' -o /output/path/FILE.ISO /input/path/
Now, however, it gives a UTR-8 character message at the start
INFO: UTF-8 character encoding detected by locale settings.
Assuming UTF-8... (0 Replies)
Discussion started by: Bobby
0 Replies
6. UNIX for Dummies Questions & Answers
Hello,
I have created a dosrename script and it was working fine unitl today. I can't think what i have changed (don't think i have to be honest). The error is when i run the script it says the file i am trying to rename does not exist when it blatently does.
Or is it a typo when i run the... (4 Replies)
Discussion started by: jazz8146
4 Replies
7. Solaris
what happened to admintool in Solaris10? (2 Replies)
Discussion started by: mndavies
2 Replies
8. What is on Your Mind?
I just found the website coolerbooks.com a couple weeks ago. It was a site that had loads of free ebooks for download.
But now it seems to have been hijacked by some Microsoft search thing.
There was an article last year claiming it teamed with Google (the anti-Microsoft!) to offer the... (2 Replies)
Discussion started by: KenJackson
2 Replies
LEARN ABOUT SUSE
drop_function
DROP
FUNCTION(7) SQL Commands DROP FUNCTION(7)
NAME
DROP FUNCTION - remove a function
SYNOPSIS
DROP FUNCTION [ IF EXISTS ] name ( [ [ argmode ] [ argname ] argtype [, ...] ] )
[ CASCADE | RESTRICT ]
DESCRIPTION
DROP FUNCTION removes the definition of an existing function. To execute this command the user must be the owner of the function. The argu-
ment types to the function must be specified, since several different functions can exist with the same name and different argument lists.
PARAMETERS
IF EXISTS
Do not throw an error if the function does not exist. A notice is issued in this case.
name The name (optionally schema-qualified) of an existing function.
argmode
The mode of an argument: IN, OUT, INOUT, or VARIADIC. If omitted, the default is IN. Note that DROP FUNCTION does not actually pay
any attention to OUT arguments, since only the input arguments are needed to determine the function's identity. So it is sufficient
to list the IN, INOUT, and VARIADIC arguments.
argname
The name of an argument. Note that DROP FUNCTION does not actually pay any attention to argument names, since only the argument
data types are needed to determine the function's identity.
argtype
The data type(s) of the function's arguments (optionally schema-qualified), if any.
CASCADE
Automatically drop objects that depend on the function (such as operators or triggers).
RESTRICT
Refuse to drop the function if any objects depend on it. This is the default.
EXAMPLES
This command removes the square root function:
DROP FUNCTION sqrt(integer);
COMPATIBILITY
A DROP FUNCTION statement is defined in the SQL standard, but it is not compatible with this command.
SEE ALSO
CREATE FUNCTION [create_function(7)], ALTER FUNCTION [alter_function(7)]
SQL - Language Statements 2010-05-14 DROP FUNCTION(7)