2015-11-05 21:29 GMT+01:00 Pavel Stehule :
>
>
> 2015-11-05 13:31 GMT+01:00 Craig Ringer :
>
>> On 5 November 2015 at 14:36, Pavel Stehule
>> wrote:
>>
>> > 1. The encapsulation and local scope - all objects in schema are
>> accessible
>> > from other objects in schema by default (can be rewritt
2015-11-05 13:31 GMT+01:00 Craig Ringer :
> On 5 November 2015 at 14:36, Pavel Stehule
> wrote:
>
> > 1. The encapsulation and local scope - all objects in schema are
> accessible
> > from other objects in schema by default (can be rewritten by explicit
> > granting). Local objects are visible o
On Thu, Nov 5, 2015 at 9:36 AM, Pavel Stehule
wrote:
> Hi
>
> I had talk about possibility to implement PL/SQL packages in Postgres.
>
> The package concept is coming from ADA language and it is partially
> foreign/redundant element in SQL world. Oracle needs it for modularization,
> because sche
On 11/05/2015 01:31 PM, Craig Ringer wrote:
On 5 November 2015 at 14:36, Pavel Stehule wrote:
[snip]
2. The schema variables - a server side session (can be emulated now) and
server side local schema session variables (doesn't exist) is pretty useful
for storing some temp data or high frequent
On 5 November 2015 at 14:36, Pavel Stehule wrote:
> 1. The encapsulation and local scope - all objects in schema are accessible
> from other objects in schema by default (can be rewritten by explicit
> granting). Local objects are visible only from objects in schema. This needs
> enhancing of ou
Hi
I had talk about possibility to implement PL/SQL packages in Postgres.
The package concept is coming from ADA language and it is partially
foreign/redundant element in SQL world. Oracle needs it for modularization,
because schema plays different role there than in Postgres. My opinion
about pa
