IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

New Postgres users: functions
Some hard-won knowledge I thought I'd share:

CREATE FUNCTION "somefunc"(args) etc.

Is not the same as:

CREATE FUNCTION somefunc(args) etc.

So if you use the quotes, then DROP FUNCTION somefunc(args); will NOT work, but DROP FUNCTION "somefunc"(args) will.

You have been warned. :-)
Regards,

-scott anderson

"Welcome to Rivendell, Mr. Anderson..."
New Thanks.
bcnu,
Mikem

The soul and substance of what customarily ranks as patriotism is moral cowardice and always has been...We have thrown away the most valuable asset we had-- the individual's right to oppose both flag and country when he (just he, by himself) believed them to be in the wrong. We have thrown it away; and with it all that was really respectable about that grotesque and laughable word, Patriotism.

- Mark Twain, "Monarchical and Republican Patriotism"
New Oracle is similar
But there it would be because when you don't quote an identifier, it is upper-cased for you. So the difference is that "somefunc" is not the same as SOMEFUNC.

I have no clue why postgres would do that.

Cheers,
Ben
"good ideas and bad code build communities, the other three combinations do not"
- [link|http://archives.real-time.com/pipermail/cocoon-devel/2000-October/003023.html|Stefano Mazzocchi]
New OT - recommend a Perl refresher project for tomorrow?
Something relatively complex but short, that touches the important language issues.

Ugh. Do I really want a job? :)

(ARGH was supposed to go in TPP)
-drl
Expand Edited by deSitter March 23, 2004, 11:28:13 AM EST
New You'll be dealing with Informix?
I'd suggest installing DBI, with some database driver (if nothing else is readily available, then DBD::SQLite because it is easy), set everything up, and try to write a small database project. Something like a URL-shortening service. (Look at [link|http://www.notlong.com/|http://www.notlong.com/] if you don't know what that is.)

That will remind you of how Perl works, remind you how the DBI interface works, and remind you where to find modules and documentation for Perl stuff.

Cheers,
Ben
"good ideas and bad code build communities, the other three combinations do not"
- [link|http://archives.real-time.com/pipermail/cocoon-devel/2000-October/003023.html|Stefano Mazzocchi]
New Thanks, excellent advice
-drl
     Postgres users: functions - (admin) - (5)
         Thanks. -NT - (mmoffitt)
         Oracle is similar - (ben_tilly) - (3)
             OT - recommend a Perl refresher project for tomorrow? - (deSitter) - (2)
                 You'll be dealing with Informix? - (ben_tilly) - (1)
                     Thanks, excellent advice -NT - (deSitter)

IFKK
107 ms