Re: Scripting issues - Mailing list pgsql-general

From Jim C. Nasby
Subject Re: Scripting issues
Date
Msg-id 20050621170306.GB84822@decibel.org
Whole thread Raw
In response to Re: Scripting issues  (postgresql@bryden.co.za)
List pgsql-general
On Tue, Jun 21, 2005 at 10:59:58AM +0200, postgresql@bryden.co.za wrote:
> Hi Richard
>
> Thanks for the suggestion. I'm sure I'll go that way.
> One other question: Since in PostgreSQL you can have "overloaded"
> functions, how do you query the system tables for the existence of a
> particular version of the function? I can query
> information_schema.routines for the function name, but not for the
> particular parameters.

If you're specifically worried about functions, why not just use CREATE
OR REPLACE?
--
Jim C. Nasby, Database Consultant               decibel@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: index selection by query planner
Next
From: Richard Huxton
Date:
Subject: Re: HELP!!! Corrupt Database!