Re: PL/pgSQL 1.2 - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: PL/pgSQL 1.2
Date
Msg-id CAFj8pRCjLzMZorVHGZNOaFAfWkisJDSThv3c8pX=tWEspH2ESQ@mail.gmail.com
Whole thread Raw
In response to Re: PL/pgSQL 1.2  (Marko Tiikkaja <marko@joh.to>)
List pgsql-hackers



2014-09-04 10:53 GMT+02:00 Marko Tiikkaja <marko@joh.to>:
On 9/4/14 10:42 AM, Pavel Stehule wrote:
2014-09-04 10:06 GMT+02:00 Joel Jacobson <joel@trustly.com>:
*) but there are probably equally who prefer to handle business logics
outside the database

It is maybe main difference between me and you. Usually I don't write CRUD
applications, and I am not sure if plpgsql is good for CRUD.

Mainly I would not to optimize plpgsql primary for CRUD.

I don't think providing syntax to support the CRUD-like use case would be "optimizing it primarily for CRUD".  Changing how UPDATE and DELETE work by default would be, but that's not being suggested here (anymore).

I am strong in opinion so safe stored procedures should be verbose. It is in contradiction to Joel direction.

I wrote a proposal, how to do more friendly but still enough verbose

Pavel
 


.marko

pgsql-hackers by date:

Previous
From: Marko Tiikkaja
Date:
Subject: Re: PL/pgSQL 1.2
Next
From: Joel Jacobson
Date:
Subject: Re: PL/pgSQL 1.2