Re: Fwd: Bug?

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