From: | Ashesh Vashi <ashesh(dot)vashi(at)enterprisedb(dot)com> |
---|---|
To: | "Guillermo E(dot) Villanueva" <guillermovil(at)gmail(dot)com> |
Cc: | pgadmin-support <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: Fwd: Bug? |
Date: | 2015-04-07 04:52:39 |
Message-ID: | CAG7mmoxNYsnVRhO3fhnAhEELBWUa6wyk_404gSnOFim+vKK7MQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
On Wed, Apr 1, 2015 at 5:55 PM, Guillermo E. Villanueva <
guillermovil(at)gmail(dot)com> wrote:
> S.O. client: Windows 7
> pgAdmin III: 1.20.0
> Server: win/lnx 9.0.13/9.0.5
>
Thanks for the information.
I will look into it.
--
Thanks & Regards,
Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company
<http://www.enterprisedb.com/>
*http://www.linkedin.com/in/asheshvashi*
<http://www.linkedin.com/in/asheshvashi>
>
> Guillermo Villanueva
>
>
> 2015-04-01 9:02 GMT-03:00 Ashesh Vashi <ashesh(dot)vashi(at)enterprisedb(dot)com>:
>
> On Wed, Apr 1, 2015 at 5:18 PM, Guillermo E. Villanueva <
>> guillermovil(at)gmail(dot)com> wrote:
>>
>>> Hi Dave and pgadmin team, how are you?
>>> First of all I want to thank you for the pgAdmin software, it's great.
>>>
>> Version of pgAdmin?
>>
>> --
>>
>> Thanks & Regards,
>>
>> Ashesh Vashi
>> EnterpriseDB INDIA: Enterprise PostgreSQL Company
>> <http://www.enterprisedb.com>
>>
>>
>> *http://www.linkedin.com/in/asheshvashi*
>> <http://www.linkedin.com/in/asheshvashi>
>>
>>
>>> I think I detected an error. The explanation Is here:
>>>
>>> *In pgAdmin III*
>>>
>>> I select one function from the Object browser and I can see source code
>>> in SQL Pane:
>>>
>>> [image: Imágenes integradas 1]
>>>
>>> *In psql:*
>>>
>>> nacer=# \df+ nacer.periodos;
>>>
>>> List of functions
>>>
>>> -[ RECORD 1
>>> ]-------+-------------------------------------------------------------------------------------------------
>>>
>>> Schema | nacer
>>>
>>> Name | periodos
>>>
>>> *Result data type | TABLE(per_fecha timestamp without time zone)*
>>>
>>> Argument data types |
>>>
>>> Type | normal
>>>
>>> Volatility | volatile
>>>
>>> Owner | postgres
>>>
>>> Language | plpgsql
>>>
>>> Source code |
>>>
>>> | declare
>>>
>>> | lts_minimo timestamp;
>>>
>>> | lts_maximo timestamp;
>>>
>>> | begin
>>>
>>> | select max(periodo), min(periodo) into lts_maximo,
>>> lts_minimo from nacer.historicotemp;
>>>
>>> | RETURN QUERY select * from
>>> generate_series(lts_minimo, lts_maximo,'1 month'::interval);
>>>
>>> | end;
>>>
>>> |
>>>
>>> Description |
>>> I hope your comments.
>>>
>>> Sorry for my english.
>>>
>>> Guillermo Villanueva
>>> Salta - Argentina
>>>
>>>
>>
>
From | Date | Subject | |
---|---|---|---|
Next Message | M. Matt Dugan | 2015-04-07 16:44:39 | Enabling debugger plugin on pgAdmin III |
Previous Message | Leonard Boyce | 2015-04-02 18:16:19 | Re: How can I test a function in the SQL window? |