Alvaro Herrera wrote:
Me too. I've created many functions to extract data that are joined to
other functions. All in all the result is not as optimal as it could
be, because the optimizer can not poke into the functions, and the
estimates about functions are only guesses. If one could use
parame
On Mon, Dec 01, 2003 at 09:38:06AM +1100, Alex Satrapa wrote:
> create or replace function get_transactions (INTEGER) returns set of
> record as '
> DECLARE
>cust_id ALIAS FOR $1;
> BEGIN
> for r in select ... from ... loop
> return next r;
> end loop;
> return;
> END
> ' language 'plpgsq
On 29/11/2003 16:24 Jason Tesser wrote:
[snip]
A programmer that doesn't document stuff needs to find a new job :-)
Agreed. So you're replaced him and inherited a documentation-free
application. How many favours has he done you by squirrelling away section
of business logic in the database?
This
Title: Re: [GENERAL] PostgreSQL Advocacy, Thoughts and Comments
Comments within:
Chris Travers wrote:
Tony <[EMAIL PROTECTED]> Wrote:
Now many
consultant/developer/sys-admins like myself are going to client site on
a contract (this is especially true in the UK, I can't speak for
"Shane D" <[EMAIL PROTECTED]> Wrote:
>
>Could someone explain to me the usefulness of views? I understand
> how they are created. I understand a single query can be created as a
> view returning all records in a single column of a single table, or
> maybe even multiple columns across many ta
CSN writes:
> I upgraded to 7.4 a few days ago and am getting these
> errors when importing dumps: "permission denied to set
> session authority" and "permission denied for schema
> public". Not all of the dump is imported successfully.
Looks like you need to restore as superuser.
--
Peter Eise
Tony <[EMAIL PROTECTED]> Wrote:
> Now many
> consultant/developer/sys-admins like myself are going to client site on
> a contract (this is especially true in the UK, I can't speak for
> anywhere else) and finding complex stocktrading systems, inventory
> systems, CRM systems, and others, all writt
"Randal L. Schwartz" <[EMAIL PROTECTED]> Wrote:
>
> The biggest advantage MySQL still has over PostgreSQL is the same
> advantage Microsoft has over Unix - entrenchment, both in
> software and mindshare.
There is another thing too-- MySQL manages connection permissions entirely
within the RDBMS, w
