Re: PLPGSQL: when the local variable used and when the table field?

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Durumdara <durumdara(at)gmail(dot)com>
Cc: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: PLPGSQL: when the local variable used and when the table field?
Date: 2020-03-25 13:50:41
Message-ID: CAKFQuwZq38PtnrithBUbe1kToEaARD59aopm1oi2HpDT9qrA+g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Mar 25, 2020 at 6:09 AM Durumdara <durumdara(at)gmail(dot)com> wrote:

>
> What would happen?
> The working procedure makes error, because it have more possible source of
> data (local variable, and table field)?
> Or it uses the local variable, because in the scope it has more precedency?
> [...]
>
> Do you know any info about the background?
>

https://www.postgresql.org/docs/12/plpgsql-implementation.html#PLPGSQL-VAR-SUBST

David J.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Mike Rylander 2020-03-25 14:36:44 Re: Replacing Apache Solr with Postgre Full Text Search?
Previous Message Durumdara 2020-03-25 13:08:56 PLPGSQL: when the local variable used and when the table field?