On Dienstag 15 September 2009 Kevin Grittner wrote:
> http://www.postgresql.org/docs/8.4/interactive/functions-string.html
>
> I would have thought convert_from, possibly combined with convert,
> would do it.
That function exists since 8.3, I'm on 8.1 on my server. Will forward it
to others, an
Kasia Tuszynska wrote on 14.09.2009 22:15:
Hello Postgres Admins,
I am having a bit of trouble setting postgres memory parameters on a
windows machine. I figured out the parameters based on postgres
documentation as well as the whack a mole slide deck, but the postgres
process will not sta
Kasia Tuszynska writes:
> I get the following error message:
> ERROR: unsupported XML feature
> DETAIL: This functionality requires the server to be built with libxml
> support.
> HINT: You need to rebuild PostgreSQL using --with-libxml.
> Is there a way to "switch on" the libxml option afte
Hello,
I am running Postgres 8.3.0 on RHEL 4, and trying to insert a value into an xml
data type:
create table test_xml (name character varying(10), iteminfo xml)
insert into test_xml values ('bob',
'xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance')
I get the following error message:
ERROR
Michael Monnerie wrote:
> On Sonntag 13 September 2009 Michael Monnerie wrote:
>> I currently have no idea how to cast bytea to text. For this
>> purpose of searching through mails, it would be enough for
>> postgres to treat the bytea as text, and just search through it.
>> You can only find a
On Sonntag 13 September 2009 Michael Monnerie wrote:
> On Donnerstag 10 September 2009 Tom Lane wrote:
> > There has *never* been a Postgres release that accepted bytea ILIKE
> > something. I'm not sure what you were really doing before, but
> > that wasn't it.
>
> You're right: That query was gen
On Tue, Sep 15, 2009 at 12:27 AM, Robert Fleming
wrote:
> On Mon, Sep 14, 2009 at 4:56 PM, Scott Marlowe
> wrote:
>>
>> On Mon, Sep 14, 2009 at 5:47 PM, Robert Fleming
>> wrote:
>> > On Mon, Sep 14, 2009 at 4:23 PM, Tom Lane wrote:
>> >>
>> >> Robert Fleming writes:
>> >> > But I would like to
