Re: Fwd: Bug?

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
>>>
>>>
>>
>