Re: help needed for functions

From: "A(dot) Kretschmer" <akretschmer(at)despammed(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: help needed for functions
Date: 2005-09-16 14:16:15
Message-ID: 20050916141615.GA6561@webserv.wug-glas.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

am 16.09.2005, um 6:51:16 -0700 mailte Nitin Ahire folgendes:
> I am facing problems for stored procedures. Is their any way so that I
> can transfer my existing stored procedure from mssql to postgre ?

I guess: no.

>
> I already read about functions & tried to implement it but I could not
> found any way to get multiple columns from a function. Also I would

http://techdocs.postgresql.org/guides/SetReturningFunctions
http://www.postgresql.org/docs/current/static/xfunc-sql.html#AEN28835

Read this links!

> like to get help about selecting values from two tables using
> function.

Where exactly is the problem?

Regards, Andreas
--
Andreas Kretschmer (Kontakt: siehe Header)
Heynitz: 035242/47212, D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
=== Schollglas Unternehmensgruppe ===

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bill Moseley 2005-09-16 14:18:25 Question about a query plan
Previous Message Peter Fein 2005-09-16 14:13:31 Re: Asychronous database replication