Re: [GENERAL] immutable functions and enumerate type casts in indexes

2008-09-03 Thread Edoardo Panfili
Tom Lane ha scritto: Edoardo Panfili <[EMAIL PROTECTED]> writes: labelDatum = DirectFunctionCall1(enum_out,datumIbrido); label = (char *) DatumGetPointer(labelDatum); Just FYI, preferred style for the second line would be label = DatumGetCString(labelDatum); Nearly al

Re: [GENERAL] immutable functions and enumerate type casts in indexes

2008-09-03 Thread Tom Lane
Edoardo Panfili <[EMAIL PROTECTED]> writes: > labelDatum = DirectFunctionCall1(enum_out,datumIbrido); > label = (char *) DatumGetPointer(labelDatum); Just FYI, preferred style for the second line would be label = DatumGetCString(labelDatum); Nearly all standard data types hav

Re: [GENERAL] immutable functions and enumerate type casts in indexes

2008-09-03 Thread Edoardo Panfili
Martijn van Oosterhout ha scritto: On Tue, Sep 02, 2008 at 10:53:03AM +0200, Edoardo Panfili wrote: But i have a little question about parameters of enum_out. Datum enum_out(PG_FUNCTION_ARGS); this is a part of my function --- Datum esterna

Re: [GENERAL] immutable functions and enumerate type casts in indexes

2008-09-02 Thread Martijn van Oosterhout
On Tue, Sep 02, 2008 at 10:53:03AM +0200, Edoardo Panfili wrote: > But i have a little question about parameters of enum_out. > Datum enum_out(PG_FUNCTION_ARGS); > this is a part of my function > --- > Datum esterna_nome2(PG_FUNCTION_ARGS){ >

Re: [GENERAL] immutable functions and enumerate type casts in indexes

2008-09-02 Thread Edoardo Panfili
Tom Lane ha scritto: Edoardo Panfili <[EMAIL PROTECTED]> writes: my enumerated type is (this is a subset) CREATE TYPE hibridation AS ENUM('none','genus','specie'); function declaration CREATE FUNCTION ename(text,boolean,text,text RETURNS text AS 'funzioniGDB.so' LANGUAGE C IMMUTABLE; inde

Re: [GENERAL] immutable functions and enumerate type casts in indexes

2008-09-01 Thread Tom Lane
Edoardo Panfili <[EMAIL PROTECTED]> writes: > my enumerated type is (this is a subset) > CREATE TYPE hibridation AS ENUM('none','genus','specie'); > function declaration > CREATE FUNCTION ename(text,boolean,text,text RETURNS text AS > 'funzioniGDB.so' LANGUAGE C IMMUTABLE; > index creation (the

[GENERAL] immutable functions and enumerate type casts in indexes

2008-09-01 Thread Edoardo Panfili
Hello, I have a problem with enumerated types in functions parameters. my enumerated type is (this is a subset) CREATE TYPE hibridation AS ENUM('none','genus','specie'); function declaration CREATE FUNCTION ename(text,boolean,text,text RETURNS text AS 'funzioniGDB.so' LANGUAGE C IMMUTABLE; i