Re: function_name.parameter_name

From: "David E(dot) Wheeler" <david(dot)wheeler(at)pgexperts(dot)com>
To: Sergey Konoplev <gray(dot)ru(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: function_name.parameter_name
Date: 2010-09-07 21:12:00
Message-ID: 1BFEDFFD-7E0E-4BB8-AB48-1BB9D8F62FD9@pgexperts.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I think so. Try it!

David

On Sep 7, 2010, at 11:39 AM, Sergey Konoplev wrote:

> Hi,
>
> On 7 September 2010 20:35, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> How does $subject differ from what we already do? See
>> http://www.postgresql.org/docs/9.0/static/plpgsql-structure.html
>
> So will it be possible to do things like this?
>
> 1.
> CREATE FUNCTION func_name(arg_name text) RETURNS integer AS $$
> BEGIN
> RAISE INFO '%', func_name.arg_name;
> ...
>
> 2.
> CREATE FUNCTION func_name() RETURNS integer AS $$
> DECLARE
> var_name text := 'bla';
> BEGIN
> RAISE INFO '%', func_name.var_name;
> ...
>
> 3.
> CREATE FUNCTION func_very_very_very_very_long_name() RETURNS integer AS $$
> << func_alias >>
> DECLARE
> var_name text := 'bla';
> BEGIN
> RAISE INFO '%', func_alias.var_name;

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Jeff Davis 2010-09-07 21:43:12 Re: "Freezing" per-role settings
Previous Message David Fetter 2010-09-07 20:30:58 Re: "Freezing" per-role settings