sad wrote:
select distinct a as F from table
union
select distinct b as F from table;
Note that UNION only returns the unique values of the union
You can get repeated values by using UNION ALL.
--
Edmund Bacon [EMAIL PROTECTED]
---(end of
hi
i have a wierd problem and i require an equally weird query.
1) backgound
Table test:
CREATE TABLE main_table (
string_A varchar( 20),
string_B varchar( 20),
);
-- both columns are identical in nature and usage
INSERT INTO
[EMAIL PROTECTED] schrieb:
hi
i have a wierd problem and i require an equally weird query.
1) backgound
Table test:
CREATE TABLE main_table (
string_A varchar( 20),
string_B varchar( 20),
);
-- both columns are identical in nature and usage
i require the dictinct values from (visualizing each column
result as a set) the union of the two columns
select distinct a as F from table
union
select distinct b as F from table;
---(end of broadcast)---
TIP 7: don't forget to increase your
On Thu, 13 May 2004, [EMAIL PROTECTED] wrote:
hi
i have a wierd problem and i require an equally weird query.
1) backgound
Table test:
CREATE TABLE main_table (
string_A varchar( 20),
string_B varchar( 20),
);
-- both columns are
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Yes you can. Try this:
(select string_A from main_table) union (select string_B from main_table)
Yasir
On Thu, 13 May 2004, [EMAIL PROTECTED] wrote:
Date: Thu, 13 May 2004 04:07:08 -0400
From: [EMAIL PROTECTED] [EMAIL PROTECTED]
To: [EMAIL
Andrei Bintintan mentioned :
= Your problem depends on what interface/programming language you're using.
Yep, I tried to do it using rules or triggers, but I can't get it to do what I want
exactly, and it's not a good idea to put any rules or triggers on my database.
I'm sticking to psql
On Thu, May 13, 2004 at 18:13:23 +,
Jaime Casanova [EMAIL PROTECTED] wrote:
Hi all, is there a way to set the isolation level to something like the
sql standard dirty read.
No. There will be a way to use the standard name in a SET command, but
you will actaully get READ COMMITTED
Hi all, is there a way to set the isolation level to something like the sql
standard dirty read.
Thanx in advance,
Jaime Casanova
_
STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
Hi all,
maybe i'm wrong (because i'm writing this without 7.3 and 7.2 at hand) but
i think when i do a \d my_table in pgsql 7.3 i get some fk info foreign key
references etc.
but in 7.4 i get
Triggers: RI_ConstraintTrigger_46753,
RI_ConstraintTrigger_46768,
Sorry it was my mistake, i was using psql from 7.2.2
_
Protect your PC - get McAfee.com VirusScan Online
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
---(end of
Sorry it was my mistake, i was using psql from 7.2.2
_
STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
http://join.msn.com/?page=features/junkmail
---(end of broadcast)---
Hi!
I'm searching a better (quicker) way to retrieve data as I used to do
using the following query...
==
SELECT
main.codice,
other.value AS value_one,
other.value AS value_two
FROM main LEFT OUTER JOIN otherON main.id =
other.id_main
LEFT
On Thursday 13 May 2004 19:27, you wrote:
sad wrote:
select distinct a as F from table
union
select distinct b as F from table;
Note that UNION only returns the unique values of the union
You can get repeated values by using UNION ALL.
read the original problem
look at the DISTINCT
On Fri, 14 May 2004, sad wrote:
On Thursday 13 May 2004 19:27, you wrote:
sad wrote:
select distinct a as F from table
union
select distinct b as F from table;
Note that UNION only returns the unique values of the union
You can get repeated values by using UNION ALL.
read the
Bruno Wolff III [EMAIL PROTECTED] writes:
On Thu, May 13, 2004 at 18:13:23 +,
Jaime Casanova [EMAIL PROTECTED] wrote:
Hi all, is there a way to set the isolation level to something like the
sql standard dirty read.
No. There will be a way to use the standard name in a SET
Marco Lazzeri [EMAIL PROTECTED] writes:
Hi!
I'm searching a better (quicker) way to retrieve data as I used to do
using the following query...
==
SELECT main.codice,
other.value AS value_one,
other.value AS value_two
FROM main
LEFT OUTER JOIN other ON
17 matches
Mail list logo