From: | Uro Gruber <uros(at)sir-mag(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | use of Function |
Date: | 2001-06-04 15:48:58 |
Message-ID: | 1088978510.20010604174858@sir-mag.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi!
Here is my problem.
I have one table with some data and i want to make some
function.
This function must do some data reordering and delete
something and then return some data.
I make almost everything exept returning data. I want return
five filelds of row and not just text.
I call this function like
SELECT myfunction(argument)
and when i call this it delete some data, then i calculate
some values and update it. And then i want outpu to
something like this.
Id | date | name | status
00304 | 24.06.01 | mike | new
CREATE function myfunction(string) RETURNS text
^^^^
how can i tell
here to return like int,datetime,varchar,varchar. Is it
possible to use return SET or something.
Now i have solution like function return me id and then i
use normal select to get this data. But i would like to have
only one function to do this.
Any sugestions.
thanks, Uros
From | Date | Subject | |
---|---|---|---|
Next Message | Lee Kwok Shing | 2001-06-04 16:08:18 | Re: upgrading a database with large objects |
Previous Message | Lee Kwok Shing | 2001-06-04 15:43:18 | PostgreSQL hangs when INSERT/UPDATE |