Re: Pet Peeves? - Mailing list pgsql-general

From Craig Ringer
Subject Re: Pet Peeves?
Date
Msg-id 49829999.5070000@postnewspapers.com.au
Whole thread Raw
In response to Re: Pet Peeves?  (Martin Gainty <mgainty@hotmail.com>)
List pgsql-general
Martin Gainty wrote:
> PROCEDUREs *which compile into Procedure Cache* and have IN/OUT (Mode) parameters..

Do you mean that as a feature request?

If you intended to say something along the lines of: "I'd like stored
procedures, invoked using 'CALL procname(params)' syntax, as distinct
from SQL or PL/PgSQL functions" ... then I do agree that'd be handy.

Their absence could easily become a peeve, especially if you use DB
interfaces that expect to invoke stored procedures this way. Some seem
to want you to jump through some hoops (switch to "native query" mode,
declare functions to the interface, etc) to call server-side functions,
but provide a convenient interface to CALL stored procedures.

--
Craig Ringer

pgsql-general by date:

Previous
From: Martin Gainty
Date:
Subject: Re: Pet Peeves?
Next
From: Scott Marlowe
Date:
Subject: Re: md5 doesn't work (Was Re: Pet Peeves?)