Thank you. Mr. Tom lane.
> One possible environment issue: what LOCALE are you running the
> postmaster in? (Check environment variables used when postmaster
> is started for LOCALE or LC_xxx variables.)
You are right. it was because of LOCALE. I upgraded a locale package to newer
one and it so
Bo Berkhaut writes:
> CREATE TABLE example (name text, slots text[]);
>
> I want to be able to select, for example, all rows such that an element
> of example.slots exists equal to example.name.
There are some operators for this in contrib/array.
However, I'd say that if you're trying to do thi
Joerg Hessdoerfer <[EMAIL PROTECTED]> writes:
> I'm experiencing somewhat confusing results using lo_creat(), lo_open(),
> lo_write()...
> First effect I have noticed is that when I write more than a certain
> amount of data at once using lo_write(), my application hangs
> indefinitely (10K work
Sungchul Park <[EMAIL PROTECTED]> writes:
> Fo2Me=# CREATE TABLE dirinfo(
> Fo2Me(# codeVARCHAR(8) PRIMARY KEY,
> Fo2Me(# level SMALLINT NOT NULL,
> Fo2Me(# nameTEXT NOT NULL,
> Fo2Me(# count SMALLINT NOT NULL DEFAULT 0
>
Hi!
Would you please explain me how can I express in PostgreSQL the notion of
"any element of the array". Having a table like:
CREATE TABLE example (name text, slots text[]);
I want to be able to select, for example, all rows such that an element
of example.slots exists equal to example.name.
So
