Re: Using LIMIT 1 in plpgsql PERFORM statements

From: "Karl O(dot) Pinc" <kop(at)meme(dot)com>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Using LIMIT 1 in plpgsql PERFORM statements
Date: 2005-10-24 00:40:18
Message-ID: 1130114418l.8670l.2l@mofo
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


On 10/23/2005 04:02:35 PM, Josh Berkus wrote:

> I'm wondering in what context it makes sense to call PERFORM on a
> constant.

I like to write PERFORMs that return a constant when
selecting from a table. It emphasizes that the
selection is being done for its side effects.

(Programs should be written for people to read
and only incidentally for computers to execute.
Programs that people can't read quickly
become useless whereas programs that can't run
quickly can be fixed. Computers are easy.
People are difficult.)

Karl <kop(at)meme(dot)com>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Christian Paul B. Cosinas 2005-10-24 01:42:33 Re: Used Memory
Previous Message Karl O. Pinc 2005-10-24 00:25:09 Re: Using LIMIT 1 in plpgsql PERFORM statements