Re: work on some tables in the same time.

From: Ian Turner <vectro(at)pipeline(dot)com>
To: Jerome Raupach <jraupach(at)intelcom(dot)fr>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: work on some tables in the same time.
Date: 2000-09-13 16:14:55
Message-ID: Pine.LNX.4.21.0009130914200.1635-100000@crafter.house
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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-----

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Stephan Szabo 2000-09-13 16:39:04 Re: work on some tables in the same time.
Previous Message Jerome Raupach 2000-09-13 15:58:05 Re: work on some tables in the same time.