SQL Server -> Postgres migration: Stored Procedure replacement?

From: "Eliel Mamousette" <eliel(at)panix(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: SQL Server -> Postgres migration: Stored Procedure replacement?
Date: 2001-04-29 17:08:02
Message-ID: 000401c0d0ce$f3081f10$2001a8c0@blockhead
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

What's the standard methodology in the Postgres world for
creating functions (SQL Server calls them 'stored procedures')
that return more than one column of data per row?

I have tried using the SETOF operand in the CREATE FUNCTION
statement, and that allows me to return more than one row,
but haven't had any luck with specifying more than one return
type and hence more than one column.

Thanks in advance for any assistance,
eliel

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message carex 2001-04-29 18:49:42 decimal point - european format
Previous Message geustace 2001-04-29 16:53:42 Re: On the _need_ to vacuum...

Browse pgsql-sql by date

  From Date Subject
Next Message LeoDeBeo 2001-04-29 19:34:29 create table
Previous Message Peter Mount 2001-04-29 10:11:23 Re: HELP : Can't load JDBC driver !