Re: [SQL] Select of a function that returns a array

2005-05-06 Thread Ramakrishnan Muralidharan
] Behalf Of Listas Evandro (Não use este endereço para mensagens pessoais) Sent: Thursday, May 05, 2005 8:08 PM To: pgsql-sql Subject: [SQL] Select of a function that returns a array Hi guys I'm trying to figure out a way to make this select work even for a wrong value: select mean_and_varian

[SQL] Select of a function that returns a array

2005-05-05 Thread Não use este endereço para mensagens pessoais
Hi guys I'm trying to figure out a way to make this select work even for a wrong value: select mean_and_variancepop('golf', 'temperature'); or select CAST (mean_and_variancepop('golf', 'temperature') AS float(2)); This function return an array the function is: CREATE or replace FUNCTION mean_a