Hello,
I had the same trouble! And It's why I install the version 6.5 of postgres. In the
6.4, you cannot make some INTERSECT.
Try to use the Intersection It's very powerfull
JK
Dirk Lutzebaeck wrote:
> Hi,
>
> I don't know if this fits into the current thread but I have also a
> problem wit
Hi All.
Once I asked already on similar subject but haven't got any reply. Try
to formulate my question on other way.
I would like to show table names and field names to users who not
familiar with databases and programming etc. Therefore I need to show
them something understandable. Postgres all
Yeah, I really need to do "external stuff" (messing with external files,
executing programs), and if I understood it correctly, PL/pgSQL can't do
that, right?
Thanks!
On qui, 19 ago 1999, you wrote:
> perhaps using PL/pgSQL is easier? in the doc there are examples,
> also, the one in the /test i
Hi,
Running PostgreSQL 6.5.1 on SGI Irix 6.5.
When I ran vacuum analyze over my database, I had an unexpected error occur:
htg=> vacuum analyze;
NOTICE: AbortTransaction and not in in-progress state
pqReadData() -- backend closed the channel unexpectedly.
This probably means the backen
Hello PostgreSQL friends!
I'm new to PostgreSQL, but I've been using MySQL/mSQL for a long time now. I
switched to PostgreSQL mostly because of it's features: triggers, specially.
I've studied, compiled and tried the examples from the crontrib/spi directory.
They all worked, but without some k
I found in the documention where you can use \tab and from playing I see I
can use \n in a string and \ooo and use an octal value, but I've not found
a way to include a character based on a hex representation of its ascii
code...
\x03
\X03
\0x03
\0X03
...all failed in cases like this ...
INSERT
Hi,
I don't know if this fits into the current thread but I have also a
problem with backends growing up to 100MB and more. This is on 6.5:
CREATE TABLE docobj (
envelopeOID NOT NULL,
docspec OID,
docindexINTEGER,
attrid INTEGER,
