On Tue, Jun 21, 2005 at 10:59:58AM +0200, [EMAIL PROTECTED] 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
On Tue, Jun 21, 2005 at 09:16:08 +0200,
[EMAIL PROTECTED] wrote:
> I come from a MSSQL background and am trying to figure out how to write
> deployment scripts for PostgreSQL. Typically, if I want to drop a
> function, I would write a script that first checks for it's existence and
> then perfo
On Jun 21, 2005, at 5:59 PM, [EMAIL PROTECTED] wrote:
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?
The pg_proc table (which contains the functions) includes a field
> [EMAIL PROTECTED] wrote:
>> Hi
>>
>> I come from a MSSQL background and am trying to figure out how to write
>> deployment scripts for PostgreSQL. Typically, if I want to drop a
>> function, I would write a script that first checks for it's existence
>> and
>> then performs the drop.
>>
>> In MSS
[EMAIL PROTECTED] wrote:
Hi
I come from a MSSQL background and am trying to figure out how to write
deployment scripts for PostgreSQL. Typically, if I want to drop a
function, I would write a script that first checks for it's existence and
then performs the drop.
In MSSQL it would be as easy as
Hi
I come from a MSSQL background and am trying to figure out how to write
deployment scripts for PostgreSQL. Typically, if I want to drop a
function, I would write a script that first checks for it's existence and
then performs the drop.
In MSSQL it would be as easy as (this can be done in nativ