You are right, this is not a correct description.
I'll just in the process of creating a test db to clarify my point and
to produce the symptom.
It'ill me take me some more time, give me an hour or so
thks
cedric
Oliveiros d'Azevedo Cristina wrote:
>
>>> Can you specify a little more how you
Can you specify a little more how you represent T1 item sets with this
data model?
(T0.id,T0.fk_T1)=(1,234),(1,235),(1,236)
234,235,236 all T1 items and 1 the set of them
What exactly represents one row from table T0? A pair (id, fk_T1) ? A
set with just one element?
one item in the set.
Th
Oliveiros d'Azevedo Cristina wrote:
>
>
>> Oliveiros d'Azevedo Cristina wrote:
>>> Howdy, Cedric .
>>>
>>> Before analysing this problem of yours further, I 'd like you to
>>> kindly clarify me some points, please
>>>
>>>
>>>
I have table following tables T0,T1,T2,T3, T1T2
with
Oliveiros d'Azevedo Cristina wrote:
Howdy, Cedric .
Before analysing this problem of yours further, I 'd like you to
kindly clarify me some points, please
I have table following tables T0,T1,T2,T3, T1T2
with
-T0(id, fk_T1)
-T1(id )
-T2(id, fk_T3)
-T1T2(fk_T1,fk_T2)
-T3 (id)
The table T
Oliveiros d'Azevedo Cristina wrote:
> Howdy, Cedric .
>
> Before analysing this problem of yours further, I 'd like you to
> kindly clarify me some points, please
>
>
>
>>
>> I have table following tables T0,T1,T2,T3, T1T2
>> with
>> -T0(id, fk_T1)
>> -T1(id )
>> -T2(id, fk_T3)
>> -T1T2(fk_T1,fk_T
Howdy, Cedric .
Before analysing this problem of yours further, I 'd like you to kindly
clarify me some points, please
I have table following tables T0,T1,T2,T3, T1T2
with
-T0(id, fk_T1)
-T1(id )
-T2(id, fk_T3)
-T1T2(fk_T1,fk_T2)
-T3 (id)
The table T0 represents sets of T1 items.
The tab
Dear members of the list.
I've tried to summarise my problem in a synthetic manner.
Stripping non necessary columns (they only contain data about the row no
relational stuff).
Giving general names to the tables.
I have table following tables T0,T1,T2,T3, T1T2
with
-T0(id, fk_T1)
-T1(id )
-T2(id,
Colin Wetherbee wrote:
Tom Hart wrote:
Let me preface this by saying hello SQL list, and I'm an idiot. My
SQL knowledge is advanced to the point of being able to use a WHERE
clause basically, so I appreciate your business. Now on to my issue
I have 3 tables I'm trying to use in this query: lo
Tom Hart wrote:
Let me preface this by saying hello SQL list, and I'm an idiot. My SQL
knowledge is advanced to the point of being able to use a WHERE clause
basically, so I appreciate your business. Now on to my issue
I have 3 tables I'm trying to use in this query: loan, share and draft
(
Tom Hart wrote:
Let me preface this by saying hello SQL list, and I'm an idiot. My SQL
knowledge is advanced to the point of being able to use a WHERE clause
basically, so I appreciate your business. Now on to my issue
I have 3 tables I'm trying to use in this query: loan, share and draft
(fo
Let me preface this by saying hello SQL list, and I'm an idiot. My SQL
knowledge is advanced to the point of being able to use a WHERE clause
basically, so I appreciate your business. Now on to my issue
I have 3 tables I'm trying to use in this query: loan, share and draft
(for those of you no
16:51
À : pgsql-sql@postgresql.org
Objet : Re: [SQL] outer join in ms query
MS Query is crippled. If you want to do much from Excel, you will need to
write code. But it's not difficult. ADO is a good choice for this.
"gad renert via DBMonster.com" <[EMAIL PROTECTED]> wr
MS Query is crippled. If you want to do much from Excel, you will need to
write code. But it's not difficult. ADO is a good choice for this.
"gad renert via DBMonster.com" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hello, I am a novice with SQL, I have 2 tables
> (transfer
On Wed, 23 Jun 2004, Zoltan Boszormenyi wrote:
> I don't know how PostgreSQL works internally but this bug *must* be
> conforming to some standard if two distinct SQL server products behave
> (almost) the same. I said almost, I discovered the same annoyance today
> on an Informix 9.21 running und
Hi,
I have a problem with LEFT OUTER JOIN, not only in PostgreSQL
but in Informix, too. I thought someone can explain the "bug"
I am seeing. Let me qoute my psql session, forgive me, it's a
bit long:
$ LANG=C psql -h localhost -U postgres postgres
Welcome to psql 7.3.4-RH, the PostgreSQL interactiv
Tomasz Myrta wrote:
Dnia 2004-02-03 07:28, Użytkownik Russell Shaw napisał:
Hi,
I'm using postgresql 7.3.4 on debian. I get bad results
from a two-table left outer join.
First table: select * from descriptions;
desc_id | description
-+-
909097 | cap
107890 | resis
Dnia 2004-02-03 07:28, Użytkownik Russell Shaw napisał:
Hi,
I'm using postgresql 7.3.4 on debian. I get bad results
from a two-table left outer join.
First table: select * from descriptions;
desc_id | description
-+-
909097 | cap
107890 | resis
223940 | ic
Hi,
I'm using postgresql 7.3.4 on debian. I get bad results
from a two-table left outer join.
First table: select * from descriptions;
desc_id | description
-+-
909097 | cap
107890 | resis
223940 | ic
447652 | electro
(4 rows)
Second table: select * from
On Sat, Mar 01, 2003 at 19:53:27 +0100,
Nicolas Fertig <[EMAIL PROTECTED]> wrote:
>
> I want to have all the row in table "table_main" with the value in the table
> "table_slave" (value or null if not exist)
>
> It is possible to have the same result without sub-select in OUTER JOIN
> (speed pr
"alexandre :: aldeia digital" <[EMAIL PROTECTED]> writes:
> SELECT A.id, B.desc from A left join B ON B.id=A.id FOR UPDATE OF A,B
> If I have a null rellation in B, the error in postgres is:
> "SELECT FOR UPDATE cannot be applied to the nullable side of an OUTER JOIN"
Yup.
> DB2 simply ignore th
Hi all,
I work with a case tool named Genexus. This tool generate the
applications in VB, VFox, Java, C, etc. in DB2, Oracle, M$ SQL and
now supports postgresql in VB and JAVA generator, making a good job
(excepting when it use a "optimize for", "/*fastfirstrows*/"
or "fast(n)" for the other 3 DB
"Richard Rowell" <[EMAIL PROTECTED]> writes:
> outer join syntax. MS has some nice syntactical sugar with the *=/=*
> operators that Postgres dosen't seem to support.
Some of us view it as "nonstandard and broken", not as "nice syntactical
sugar" ;-).
> I'm just not grasping how one would accom
Subject: [SQL] Outer Join Syntax
> I'm doing a feasability study on porting our flagship product to Postgres
> (from MS_SQL). I have run across a few snags, the largest of which is the
> outer join syntax. MS has some nice syntactical sugar with the *=/=*
> operators that
I'm doing a feasability study on porting our flagship product to Postgres
(from MS_SQL). I have run across a few snags, the largest of which is the
outer join syntax. MS has some nice syntactical sugar with the *=/=*
operators that Postgres dosen't seem to support. I am confused on how
to repli
On Mon, 15 Jan 2001, Mauricio Hipp Werner wrote:
MHW> in oracle the is used (+)
MHW> in sybase the is used * and
MHW> in postgreSql?
In PostgreSQL we have no outer joins at all. But it is promised they
are going to arrive soon, perhaps in 7.1?
Bye Borek
--
I need help, which is the symbol used in postgreSql to carry out the outer
join.
in oracle the is used (+)
in sybase the is used * and
in postgreSql?
thank you
Hipp Mauricio
The statement "Outer Join" is not available in Postgres ?
Is there an extension provided by a third company that implement this
functionnality ?
If not do you know when this functionnality will be available in
Postgres ?
Thank
Fred
--
TechBourse : le premier site en FRANCAIS dédié le NASDAQ
Hello,
There are 2 ways of doing outer joins, both are relatively expensive
from the CPU time point of view
1. Create a function that returns the ojined value, or null if the value
does not exists in the secod table
2. Use a union beetwen a left join and a straight select with a wh
There is no OUTER JOIN in postgres. You could use SELECT and UNION ALL.
Jesus.
On Mon, 12 Jun 2000, Patrick Kay wrote:
> I am looking for a way run an outer join in psql. Can anyone help?
>
> Informix has an "OUTER" keyword. I don't see anything like this in the docs
> for psql.
>
> Thanks
On Mon, 12 Jun 2000, Patrick Kay wrote:
> I am looking for a way run an outer join in psql. Can anyone help?
>
> Informix has an "OUTER" keyword. I don't see anything like this in the docs
> for psql.
>
> Thanks much.
> -Pat Kay
Here is an example I have about simulating an outer join in Post
See the FAQ. It involves UNION.
> Patrick Kay wrote:
> >
> > I am looking for a way run an outer join in psql. Can anyone help?
> >
> > Informix has an "OUTER" keyword. I don't see anything like this in the docs
> > for psql.
>
> There are many examples on how to do this in the archives or
Patrick Kay wrote:
>
> I am looking for a way run an outer join in psql. Can anyone help?
>
> Informix has an "OUTER" keyword. I don't see anything like this in the docs
> for psql.
There are many examples on how to do this in the archives or via
deja.com's power search.
Regards,
Ed Loehr
On Mon, 12 Jun 2000, Patrick Kay wrote:
> I am looking for a way run an outer join in psql. Can anyone help?
>
> Informix has an "OUTER" keyword. I don't see anything like this in the docs
> for psql.
>
> Thanks much.
> -Pat Kay
>
Hmmm... I don't now the exact definition of outer join.
I f
I am looking for a way run an outer join in psql. Can anyone help?
Informix has an "OUTER" keyword. I don't see anything like this in the docs
for psql.
Thanks much.
-Pat Kay
34 matches
Mail list logo
