Qestion about CREATE FUNCTION

From: "Cornelia Boenigk" <poppcorn(at)cornelia-boenigk(dot)de>
To: "pgsql-general" <pgsql-general(at)postgresql(dot)org>
Subject: Qestion about CREATE FUNCTION
Date: 2002-03-01 21:10:50
Message-ID: 001d01c1c165$bb236040$aec1fea9@zwerg98
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all

I defined the following function:

CREATE FUNCTION ka(member)
RETURNS member AS
'UPDATE member SET m_email = ''unbekannt'' WHERE m_email = NULL:
SELECT * FROM member;'
LANGUAGE 'sql';

If I call
SELECT ka(member) FROM member;
ka
-------------
12257440
.....

I get this number as many times as the table consists rows (no matter
weather they were updated or not). Could anybody tell me what kind of
result this is? What does this number mean?

If I use the notation with $1 like in the Programmers Guide in chapter
13.1.3 I get a parsing error. (??)

Could anybody explain this behaviour?

Thanks and greetings
Conni

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jean-Luc Lachance 2002-03-01 21:33:42 Re: improving performance of UNION and ORDER BY
Previous Message John Oakes 2002-03-01 20:41:17 Index doesn't appear to be working.