Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

Next:From: Jeff DavisDate: 2010-09-07 21:43:12
Subject: Re: "Freezing" per-role settings
Previous:From: David FetterDate: 2010-09-07 20:30:58
Subject: Re: "Freezing" per-role settings

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group