s an easier way beacuase in
the real scenario we're dealing with nearly 100 tables depending on that
single one with the primary key...
Thanks in advance,
Patrik Kudo
---(end of broadcast)---
TIP 8: explain analyze is your friend
Hi and thanks for your reply!
Martijn van Oosterhout wrote:
Now to the problem. We want to merge rows with id = 2 and id = 4 into id
= 1 in the asdf table with the qwert table beeing updated to reflect the
change. The desired result would yeild:
Why doesn't:
update quert set data = 1 where d
f you need to sort in some way you could use something like
select col1, col2, ... coln from tablename order by col1 limit 20
Regards,
Patrik Kudo
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
select * from Apples where lower(color) like '%red%';
ech`echo xiun|tr nu oc|sed 'sx\([sx]\)\([xoi]\)xo un\2\1 is xg'`ol
Känns det oklart? Fråga på!
On 9 Sep 2001, Michael Gay wrote:
> If I am doing a command such as
>
> select * from Apples where color like '%red%';
>
> how do I make it case i
I worry? =)
Regards,
Patrik Kudo
(I'm sorry if this becomes a repeated post. I tried to mail last night,
but my subscription to the list wasn't registered at that time, so the
mail didn't seem to get through)
you use "workorder". Is that where
the fault is?
You might also want to try the following:
SELECT e.emp_id FROM employee e WHERE NOT EXISTS (SELECT 1 FROM salesorder s
WHERE e.emp_id = s.emp_id)
Regards,
Patrik Kudo
> Has anyone encountered this before? I know the second query
Hi!
I'm not 100% sure, but I think it would be much faster if you use COPY
instead of INSERT when you read in a lot of data from a file.
Regards,
Patrik Kudo
--
ech`echo xiun|tr nu oc|sed 'sx\([sx]\)\([xoi]\)xo un\2\1 is xg'`ol
Känns det oklart? Fråga på!
On Wed, 18 Apr 200