On 5 apr 2006, at 18.37, Jonas F. Henriksen wrote:
ehh, sorry, yes, I also want to retrieve other values from the table,
but I left them out for clarity (which made it maby less clear...).
Maybe it makes more sense if you define the table as
CREATE TABLE testtable (
depth integer,
measur
Thanks Tom, that worked great!!
Regards Jonas:))
On Wed, 2006-04-05 at 15:09 -0400, Tom Lane wrote:
> "Jonas F. Henriksen" <[EMAIL PROTECTED]> writes:
> > Well, the problem is I want the result on one row for each depth, so it
> > will fit nicely into a table, like this:
>
> > depth measuretype
"Jonas F. Henriksen" <[EMAIL PROTECTED]> writes:
> Well, the problem is I want the result on one row for each depth, so it
> will fit nicely into a table, like this:
> depth measuretype1_value measuretype2_value
> 101.782.55
> 202.12
> 303.12
> 401.3 1.4
I thi
On 5 apr 2006, at 18.37, Jonas F. Henriksen wrote:
ehh, sorry, yes, I also want to retrieve other values from the table,
but I left them out for clarity (which made it maby less clear...).
Maybe it makes more sense if you define the table as
CREATE TABLE testtable (
depth integer,
measur
Well, the problem is I want the result on one row for each depth, so it
will fit nicely into a table, like this:
depth measuretype1_value measuretype2_value
10 1.782.55
20 2.12
30 3.12
40 1.3 1.4
...with missing rows for a depth appearing as missing values
Hi,
ehh, sorry, yes, I also want to retrieve other values from the table,
but I left them out for clarity (which made it maby less clear...).
Maybe it makes more sense if you define the table as
CREATE TABLE testtable (
depth integer,
measuretype integer,
operation integer,
valu
On 5 apr 2006, at 16.39, Jonas F. Henriksen wrote:
Hi,
I'm working with postgres and I have a question regarding a self-
join on
my table (se below for table definition and testdata):
I want to retrieve all depths that have either a measuretype=1040 or a
measuretype=4001 or both.
All hel
Hi,
I'm working with postgres and I have a question regarding a self-join on
my table (se below for table definition and testdata):
I want to retrieve all depths that have either a measuretype=1040 or a
measuretype=4001 or both. I've tried:
select * from
testtable t1
full outer join testtable
