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