Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group