On Tue, 2004-07-27 at 09:55, Prabu Subroto wrote:
> PS>and if the view changes, does it also change the
> related record in table "appointment0" and "appointment1"?
Yes, because a view is pretty much just a stored query (Pg does't have
materialised views).
CREATE VIEW apointment0 AS
On Tue, 2003-07-01 at 01:12, Madhavi Daroor wrote:
> Hi all,
> I have installed postgres 7.3 in my Red hat linux 7.2 system. I want to
> also install postgres 7.2.3 in the same system. Is it possible?? Can
> somebody please tell me how I can do this...ASAP!!!
Easy, just change the PREFIX to a
On Tue, 2003-07-22 at 19:27, VanL wrote:
> I have three queries that are essentially identical. Two of them run in
> fractions of a second; one of them takes longer than 15 minutes to
> return. (Not sure how long it totally takes, that has been the limit of
> my patience.)
>
> The only differe
On Tue, 2003-09-30 at 07:06, Mike Mascari wrote:
[snip]
> CREATE INDEX i_employees ON employees(lower(name));
>
> Let's also assume that the lower() function is computationally
> expensive. Now if I have a query like:
>
> SELECT lower(name)
> FROM employees
> WHERE lower(name) = 'mike'
>
> will
On Tue, 2003-09-30 at 09:54, Mike Mascari wrote:
> Arguile wrote:
>
> > On Tue, 2003-09-30 at 07:06, Mike Mascari wrote:
> >
> >>CREATE INDEX i_employees ON employees(lower(name));
> >>
> >>Let's also assume that the lower() function is computa
