[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
On Fri, 6 Oct 2000, K Parker wrote:
> But MS Access is _both_, remember? The question
> came up when migrating from Access talking to
> its own local Jet database to Access talking
> to pgsql via odbc. I'm not sure there is a
> way to tell Access to consider a particular
> text field in a remo
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
> My interpretation would be that if the
> consumer of the data wants to display
> it as a hyperlink, fine, but that that
> is the job of the application not the
> database
But MS Access is _both_, remember? The question
came up when migrating from Access talking to
its own local Jet database
Frank Joerdens <[EMAIL PROTECTED]> writes:
> Can I go around bragging to my SQL-minded friends about using this
> really cool thing that no other database has, or should I keep my mouth
> shut because it's actually not so cool?
IMHO it's pretty cool. You get the benefits of BLOB storage without
[EMAIL PROTECTED] writes:
> I would like to move some data from an older installation of PostgreSQL to
> a newer. When doing
> "pg_dump persondb > db.out" I get the following error message:
> "dumpSequence(person_sek): 0 (!=1) tuples returned by SELECT"
> The "person_sek" is a sequence in the da
>
> I would like to move some data from an older installation of PostgreSQL to
> a newer. When doing
> "pg_dump persondb > db.out" I get the following error message:
>
> "dumpSequence(person_sek): 0 (!=1) tuples returned by SELECT"
>
> The "person_sek" is a sequence in the database.
>
I believ
Brook Milligan wrote:
>
>But I think that hyperlinks would be a good addition to data types
>repertoire to pgsql.
>
> And how would the behavior of such a datatype differ from, for
> example, a text datatype? My interpretation would be that if the
> consumer of the data wants to display
Adam Haberlach <[EMAIL PROTECTED]> writes:
> I've been getting this on and off in my vaccums. Once it happens, the only way to
> make it go away seems to be a dump/restore. Is this bad, Bad, or BAD?
> NOTICE: FlushRelationBuffers(rawbebugs, 4400): block 287 is referenced (private 0,
>global 1
But I think that hyperlinks would be a good addition to data types
repertoire to pgsql.
And how would the behavior of such a datatype differ from, for
example, a text datatype? My interpretation would be that if the
consumer of the data wants to display it as a hyperlink, fine, but
that th
10 matches
Mail list logo
