Re: Fwd: Bug?

S.O. client: Windows 7

pgAdmin III: 1.20.0

Server: win/lnx 9.0.13/9.0.5

http://www.linkedin.com/in/asheshvashi 

Guillermo Villanueva

2015-04-01 9:02 GMT-03:00 Ashesh Vashi <ashesh.vashi@enterprisedb.com>:

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

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