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.179370@germanynet.de und
>martin.jacobs@an-netz.de
>Registered Linux User #87175
>