tuanhoanganh <[EMAIL PROTECTED]> writes:
> I write script in Query of pgAdminIII
> ...
> In functions, I have a new function test. But when I choose "CREATE
> script" with function test the script change to
> -- Function: test(ud_stt_rec(24))
> -- DROP FUNCTION test(ud_stt_rec(24));
> CREATE OR
On 2/22/08, Tom Lane <[EMAIL PROTECTED]> wrote:
> tuanhoanganh <[EMAIL PROTECTED]> writes:
> > ... But when I dump database and restore to 8.3 this function change to
>
> > CREATE OR REPLACE FUNCTION post_ctpt1(ud_stt_rec(24))
>
> It works as expected for me. Please provide a *complete* test case,
tuanhoanganh <[EMAIL PROTECTED]> writes:
> ... But when I dump database and restore to 8.3 this function change to
> CREATE OR REPLACE FUNCTION post_ctpt1(ud_stt_rec(24))
It works as expected for me. Please provide a *complete* test case,
including the specific dump and reload procedures you are
I have function in PostgreSQL 8.2
CREATE OR REPLACE FUNCTION post_ctpxd(ud_stt_rec)
RETURNS void AS
$BODY$DECLARE
...
BEGIN
END
$BODY$
LANGUAGE 'plpgsql' VOLATILE;
My domain in 8.2
CREATE DOMAIN ud_stt_rec
AS character(20)
DEFAULT ''::bpchar
NOT NULL;
But when I dump databa
On Sun, Jan 02, 2005 at 12:56:52PM -0800, David Fetter wrote:
>
> Other people have made suggestions about recompiling PostgreSQL,
> hacking the source code, etc., etc. These are things you should only
> attempt when you are absolutely certain that there is no other way to
> do what you need to d
On Sun, Jan 02, 2005 at 01:31:22AM +, Oluwatope Akinniyi wrote:
> Hi,
>
> Compliments of the season.
>
> I tried to create a function with about 60 input parameters and got
> an error message that a function cannot take more than 32
> parameters.
Generally, a function with that many input pa
Maybe you could use arrays as some function parameters ?
Can you explain why you need so many parameters ?
On Sat, 1 Jan 2005 22:25:02 -0700, Michael Fuhr <[EMAIL PROTECTED]> wrote:
On Sun, Jan 02, 2005 at 01:31:22AM +, Oluwatope Akinniyi wrote:
I tried to create a function with abo
On Sun, Jan 02, 2005 at 01:31:22AM +, Oluwatope Akinniyi wrote:
> I tried to create a function with about 60 input parameters and got an
> error message that a function cannot take more than 32 parameters.
What's the function's purpose? Why does it need so many arguments?
You might be able
Hi,
Compliments of the season.
I tried to create a function with about 60 input parameters and got an
error message that a function cannot take more than 32 parameters.
Is there a way around this? Or Am I in error?
Best regards.
Tope
--
---(end of broadcast)--
Iker Arizmendi <[EMAIL PROTECTED]> writes:
> How are function parameters of rowtype specified when
> calling them from a client such as libpq?
Something like
select myfunc(t.*) from tab t where ...
regards, tom lane
---(end of broadcast)---
How are function parameters of rowtype specified when
calling them from a client such as libpq? Is there a syntax
similar to that for arrays? (eg, {x, y, z} )
Thanks,
Iker
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please sen
11 matches
Mail list logo
