>
> 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
>