unions on views (workaround?)

Started by Paulo Parolaabout 25 years ago1 messagesgeneral
Jump to latest
#1Paulo Parola
pgsql@brazilinfo.com

Hi,

I am currently porting a database from MS Access to PostgreSQL. I have many views and occasionally some UNIONS among these VIEWS.

I have to keep PostgreSQL 7.0.2 for the moment (that's what my ISP provides).

So I need to know if anyone has any suggestions about how to simulate a union among two views with SQL (I don't want to put this inteligence into the application).

TIA,

Paulo Parola
pgsql@brazilinfo.com