Re: Newbie, Howto access Array-Slots in user defined functions?

>
> SELECT DISTINCT c FROM table;
>
>I get
>
>ERROR: There is no operator '<' for types '_bytea' and '_bytea'
> You will either have to retype this query using an explicit cast,
> or you will have to define the operator using CREATE OPERATOR
>
>To create an operator I need a function, so let's beginn with a
>compare function:
>
> CREATE FUNCTION lessbyte (_bytea, _bytea) RETURNS bool AS
> 'SELECT $1[1] < $[2];' LANGUAGE 'sql';

Shouldn't the above be:
SELECT $1[1] < $1[2] ?

You probably need the field reference in both places. I have never used
arrays so I don't know if I'm way off base but it seems logical.

Len Morgan

>
>I get
>
> ERROR: parser: parse error at or near "["
>
>Any hint, how to overcome this?
>
>Martin
>
>--
>Martin Jacobs * Windsbach * 100(dot)179370(at)germanynet(dot)de und
>martin(dot)jacobs(at)an-netz(dot)de
>Registered Linux User #87175
>