default parameters

From: Andrey Vinogradov <octonog(at)gmail(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: default parameters
Date: 2012-07-02 11:04:31
Message-ID: CAJb-vw+62RmbT0X4fmXnt_yQm_==cv9XAbyiOoDSX8_tfz7ebQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hi,

There is a function with the default parameter:

CREATE OR REPLACE FUNCTION test(p_int integer *default 1*)
RETURNS void AS
$BODY$declare
begin
--foo;
end;$BODY$
LANGUAGE plpgsql VOLATILE
COST 100;

The object browser of the pgAdmin III has been refreshed more than once.
The SQL query of the test fuction is

CREATE OR REPLACE FUNCTION test(p_int integer) -- <=== default value is
disappear
RETURNS void AS
$BODY$declare
begin
--foo;
end;$BODY$
LANGUAGE plpgsql VOLATILE
COST 100;

pgAdmin III Version 1.14.3 (Jun 1 2012, rev:REL-1_14_3)
postgresql-9.1.4-1-windows-x64
Windows 7
--

Thanks and best wishes,
Andrei Vinogradov

email: octonog(at)gmail(dot)com

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Guillaume Lelarge 2012-07-02 20:44:29 Re: Prevent loss of query text when pgAdmin crashes or freezes
Previous Message Evan Martin 2012-07-02 02:32:40 Prevent loss of query text when pgAdmin crashes or freezes