how to create a multi columns return function ?

From: jclaudio(at)capitol(dot)fr
To: pgsql-sql(at)postgresql(dot)org
Subject: how to create a multi columns return function ?
Date: 2003-10-21 13:08:28
Message-ID: OFC6DC4FE3.EDDE1832-ONC1256DC6.004816D3-C1256DC6.00482FCD@capitol.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi

I'm moving databases from sybase to postgres.
But I have difficulties in creating a postgres equivalent to the sybase
stored procedures...

Apparently, Postgres functions should work, but the syb stored procedures
get only one parameter and return several colums

Here's the code I wrote in postgresql :

create function function_name( int ) returns text
AS ' SELECT column1, column2, column3,...,column15
FROM table_name
WHERE colum1 = $1 AND column5 = \'specific value\' AND column8 =
\'specific_value2 \' '
LANGUAGE 'SQL';

and I get the message error : returns multi columns

I'm wondering too if It's possible to create a view with a parameter if
functions don't work.

Has anybody faced the same problem ?

I need help

thanks

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Wilhelm Graiss 2003-10-21 13:58:20 plpgsql related question: intervals and variables
Previous Message geraldo 2003-10-21 12:25:14 function problem