Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group