Re: Fwd: Bug?

S.O. client: Windows 7
pgAdmin III: 1.20.0
Server: win/lnx 9.0.13/9.0.5

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