On Wed, Apr 1, 2015 at 5:18 PM, Guillermo E. Villanueva <
guillermo...@gmail.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
>
>

Reply via email to