how to create a multi columns return function ?

From: jclaudio(at)capitol(dot)fr
To: pgsql-novice(at)postgresql(dot)org
Subject: how to create a multi columns return function ?
Date: 2003-10-21 13:37:16
Message-ID: OF85EC3ADD.CB4C28BD-ONC1256DC6.004ABFB0-C1256DC6.004AD2C7@capitol.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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-novice by date

  From Date Subject
Next Message Stephan Szabo 2003-10-21 15:31:53 Re: Custom function problems
Previous Message Michael Glaesmann 2003-10-21 12:09:56 Many joins: monthly summaries S-L--O--W