Re: work on some tables in the same time. - Mailing list pgsql-sql

From Ian Turner
Subject Re: work on some tables in the same time.
Date
Msg-id Pine.LNX.4.21.0009130914200.1635-100000@crafter.house
Whole thread Raw
In response to Re: work on some tables in the same time.  (Jerome Raupach <jraupach@intelcom.fr>)
List pgsql-sql
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

> testdb=#CREATE VIEW tableselecttemp AS SELECT DISTINCT f1, f2, f3 FROM
> table1_n;
> ERROR:  DISTINCT not supported in views

In that case, you'll have to create a temporary table instead. This may
actually be faster, because you only have to search table1_n once.

Ian
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.1 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQE5v6gBfn9ub9ZE1xoRAh1GAKC7SvP2orhC9lZsC0BJaqntXGlmOQCfTwj4
/Qmr4PIfcE7Ue9UEZAWGhrM=
=VV5w
-----END PGP SIGNATURE-----



pgsql-sql by date:

Previous
From: Jerome Raupach
Date:
Subject: Re: work on some tables in the same time.
Next
From: Stephan Szabo
Date:
Subject: Re: work on some tables in the same time.