Postgres Pro
Downloads
Home   >   mailing lists

Re: UNION help - Mailing list pgsql-general

From Dann Corbit
Subject Re: UNION help
Date
Msg-id D425483C2C5C9F49B5B7A41F894415470100068F@postal.corporate.connx.com
Whole thread Raw
In response to UNION help  ("Robert James" <srobertjames@gmail.com>)
List pgsql-general
Tree view

SELECT ‘1st Query’ as whichone, col1, col2, col3 from table1

UNION

SELECT ‘2ND Query’ as whichone, col1, col2, col3 from table2

 

From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Robert James
Sent: Thursday, May 17, 2007 12:11 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] UNION help

 

Is there anyway to tell if the records in a union came from the 1st query or the second?
Can I modify the individual queries to let me know this?

pgsql-general by date:

Previous
From: "Jan Bilek"
Date:
Subject: Re: JDBC - Prepared statements and PostgreSql Time/Date operations
Next
From: Shane
Date:
Subject: Database corruption