On Wed, Jan 10, 2007 at 04:34:00PM +0100, riki wrote:
> Hi,
>
> i'm trying to extract some info from system catalog tables.
> documentation says that i should join columns of different data type.
> that is int2[] with int2, array with integer.
> how can i make this join work?
You can use the ANY(
Hi,
i'm trying to extract some info from system catalog tables.
documentation says that i should join columns of different data type.
that is int2[] with int2, array with integer.
how can i make this join work?
thanks
http://www.postgresql.org/docs/7.4/static/catalog-pg-constraint.html
co
On Wed, 23 Jul 2003, Rob Sell wrote:
> Ok I was going to send in the schema from both db's and when trying to get
> the schema through phppgadmin it works fine on the old db, but on the new db
> I get this error "PostgreSQL said: ERROR: Relation "pg_relcheck" does not
> exist"
>
> What is that?
lated to my problem?
Rob
-Original Message-
From: scott.marlowe [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 23, 2003 2:55 PM
To: Rob Sell
Cc: [EMAIL PROTECTED]
Subject: Re: [GENERAL] Join Problem
On Wed, 23 Jul 2003, Rob Sell wrote:
> We are migrating to a new database server and on
On Wed, 23 Jul 2003, Rob Sell wrote:
> We are migrating to a new database server and one piece of code doesn't work
> from the old to new.
> Old server is 7.2.1
> New server is 7.3.2
>
> The sql in question is "Select * from inven as i Left Outer Join conn_xr as
> c on i.partnum = c.facpn"
>
> T
We are migrating to a new database server and one piece of code doesn't work
from the old to new.
Old server is 7.2.1
New server is 7.3.2
The sql in question is "Select * from inven as i Left Outer Join conn_xr as
c on i.partnum = c.facpn"
This produces the desired effects on the 7.2.1 server but
