Re: Using LIMIT 1 in plpgsql PERFORM statements - Mailing list pgsql-performance

From Karl O. Pinc
Subject Re: Using LIMIT 1 in plpgsql PERFORM statements
Date
Msg-id 1130114418l.8670l.2l@mofo
Whole thread Raw
In response to Re: Using LIMIT 1 in plpgsql PERFORM statements  (Josh Berkus <josh@agliodbs.com>)
Responses Re: Using LIMIT 1 in plpgsql PERFORM statements  (Josh Berkus <josh@agliodbs.com>)
List 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@meme.com>
Free Software:  "You don't pay back, you pay forward."
                  -- Robert A. Heinlein


pgsql-performance by date:

Previous
From: "Karl O. Pinc"
Date:
Subject: Re: Using LIMIT 1 in plpgsql PERFORM statements
Next
From: "Christian Paul B. Cosinas"
Date:
Subject: Re: Used Memory