From: | Ralph Graulich <maillist(at)shauny(dot)de> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | create function: number of parameters |
Date: | 2002-07-15 22:23:16 |
Message-ID: | Pine.LNX.4.21.0207160019110.11301-100000@shauny.shauny.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
although I've been using databases for more than ten years by now, I am
rather new to postgres and stumbled upon a problem. I tried to isolate all
the application's logic dealing with data by putting all input and output
into functions.
So instead of writing complex insert/update statements, for inserting a
new record, I just want to call a function with the necessary
parameters. For example, I want to create a new customer, by calling:
SELECT create_customer('name', 'christian name', 'street', 'mailbox',
'location', 'phone number');
The function "create_customer" deals with the data and updates several
tables accordingly. My problem is, that postgres tells me I can't use more
than 16 parameters. For those basic "create" functions I need more than 40
parameters. Is there any easy way to accomplish this or do you have any
good hints for me?
Best regards
... Ralph ...
From | Date | Subject | |
---|---|---|---|
Next Message | Christopher Weimann | 2002-07-15 22:33:19 | Re: MySQL vs. PostgreSQL |
Previous Message | igor | 2002-07-15 22:04:31 | Re: Disabling case sensitivity |