Hi
Is there any way to create nested function?
oracle to postgres migration required super function variable reference
into nested function without nested function parameter
Oracle sample:
---
create or replace function f1(n number) return number
is
vs number:=1;
Hi
2016-03-28 6:14 GMT+02:00 Sridhar N Bamandlapally :
> Hi
>
> Is there any way to create nested function?
>
Some languages supports this feature, like plv8, but plpgsql doesn't
support it,
You have to use two function and some implementation of session variables.
Regards
Pavel
>
> oracle t
On Sun, Mar 27, 2016 at 9:14 PM, Sridhar N Bamandlapally <
sridhar@gmail.com> wrote:
> Hi
>
> Is there any way to create nested function?
>
> oracle to postgres migration required super function variable reference
> into nested function without nested function parameter
>
> Oracle sample:
> --
Hello
I have 2 tables and I must make asure unique values like this.
table1
id
nr - integer
table2
id
id_table1 - FK in Table 1
valid_from - timestamp
There must be unique values for:
- nr - from table1
and
- YEAR(MIN(valid_from)) from table 2
I already made this with a function but in rare c
I think I fixed the problem by executing the function AFTER insert or
update but I'm not sure.
Until now the execution was before insert or update.
-- Original Message --
From: "Sterpu Victor"
To: "PostgreSQL General"
Sent: 28/3/2016 9:32:17 AM
Subject: [GENERAL] Unique values on multi