;
Sent: Wednesday, May 09, 2001 8:34 AM
Subject: [GENERAL] Newbie HOWTO
> Hello,
>
> Does any one know where I can find a postresql howto for newbies not
> familiar with SQL? Linux/Unices not a problem tho.
>
> Thanks all!
>
>
>
> ---(
[EMAIL PROTECTED] (Martin Jacobs) writes:
> Thank your for this hint, but my 6.3.2 installation does not know
> a function get_byte().
6.3.2? You didn't mention that before. There are a ton of
array-related bugs in 6.3.2. Try a more recent release.
regards, tom lane
Tom Lane wrote:
>
> [EMAIL PROTECTED] (Martin Jacobs) writes:
> > CREATE FUNCTION lessbyte (_bytea, _bytea) RETURNS bool
> > AS
> > 'SELECT $1[1] < $2[1];' LANGUAGE 'sql';
> > ERROR: Unable to identify an operator '<' for types 'bytea'
> > and 'bytea'
> > You will have
[EMAIL PROTECTED] (Martin Jacobs) writes:
> CREATE FUNCTION lessbyte (_bytea, _bytea) RETURNS bool AS
> 'SELECT $1[1] < $2[1];' LANGUAGE 'sql';
> ERROR: Unable to identify an operator '<' for types 'bytea' and 'bytea'
> You will have to retype this query using an explicit cast
Hi Len,
Len Morgan schrieb:
> >
> > 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 OPERA
