Concept about stored procedures

From: Marcos <marcos(at)auriance(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Concept about stored procedures
Date: 2006-01-11 17:13:01
Message-ID: 1136999581.1101.23.camel@servidor
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I'm developing one application using this wonderful Database, and I've
like of use the concepts correctly.

Then, i decided that all my SQL statements will be in database using the
procedure language (plpgsql or plpython), I go create functions for all
interactions in database, and use in the my application the SELECT for
call him.

Is its the correct way of working? Or the correct way is create
procedure functions for big and complex statements?

The application will work with a large Database and will have many
simultaneous access.

Very Thanks!!!!

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2006-01-11 18:24:30 Re: cursors as table sources
Previous Message Tom Lane 2006-01-11 16:37:05 Re: Connection specific information - Temporary table used