Hi!
Is there a way to use output parameters with a pl/python fucntion?
I've tried with no luck: if I define out parameters, it says return type
must be record, if I define a record return type, I get an error on
executing that pl/python doesn't support record return type...
My simple test func is
Hello,
I have just installed version 8.4 of PostGresql (on a Windows machine)
in order to use SKYLINE command, but it seems that I get an error each
time I try to use this command.
Is there a specific plugin to install to add SKYLINE command ? Can you
help me on this point to get this comm
first define a custom type, then drop the out parameters.
create type mytype as (
i integer,
j text );
create or replace function outtest()
returns mytype as
$BODY$
i = 1
j = 'something'
return ( i, j )
$BODY$
language plpythonu;
select * from outtest();
i | j
---+---
1 | someth
Imre Horvath writes:
> Is there a way to use output parameters with a pl/python fucntion?
At the moment I think plpython only supports a single OUT param.
regards, tom lane
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscriptio
Remind: PIC-2010 last Call for Papers - few days left-deadline August 10th!
Please subimit your papers before August 10th.
-
2010 International Conference on Progress in Informatics and Computing(PIC-2010
)
Impor
Hello postgresql users,
I have a question regarding building a tsearch2 query that does wildcard
searching by default. Currently, I am using plainto_tsquery(), but it
does not allow me to build more advanced search expressions. I know
to_tsquery is the way to go with this, but I need some qualifie
On 05/08/10 00:26, LaboRecherche wrote:
>
>
> Hello,
>
> I have just installed version 8.4 of PostGresql (on a Windows machine)
> in order to use SKYLINE command, but it seems that I get an error each
> time I try to use this command.
>
> Is there a specific plugin to install to add SKYLINE com
